Qlik_069: AutoNumber02_How to use AutoNumber() function for composite keys and Link table. скачать в хорошем качестве

Qlik_069: AutoNumber02_How to use AutoNumber() function for composite keys and Link table.

In this video, we will see 1) How to create composite keys and Link Table? 2) How to use AutoNumber() for composite keys? 3) How to use AutoNumber as a statement instead of function? 00:00:00 – 00:01:15 Introduction and table load. 00:01:16 – 00:02:40 Convert MonthYear field to proper datetime/date/daul format. 00:02:41 – 00:03:40 Create composite key. 00:03:41 – 00:07:30 Create link table and remove synthetic key and synthetic table. 00:07:31 – 00:08:45 Implement AutoNumber() function on composite key. 00:08:46 – 00:11:20 Repeat same steps for another table. 00:08:46 – 00:12:40 Implementing AutoNumber() function along with AutoID (2nd parameter) 00:12:41 – 00:16:50 Implementing AutoNumber using Statement. If you want to read about AutoNumber() function from Qlik help https://help.qlik.com/en-US/sense/Nov... If you want to read about AutoNumber statement from Qlik help https://help.qlik.com/en-US/sense/Aug.... Few good blogs on AutoNumber()   / qlikview-autonumber-autonumberhash-functio...   https://qlikviewcookbook.com/2018/04/... https://www.naturalsynergies.com/q-ti... http://poverconsulting.com/2014/01/30... https://www.qlikviewaddict.com/2014/0... https://community.qlik.com/t5/Design/... Download content of this video https://drive.google.com/drive/folder... You can also find me on YouTube:    / @manishkumarkachhia1683   Facebook: https://www.facebook.com/profile.php?... LinkedIn:   / manishkachhia   Twitter:   / mk_qsl   Udemy: https://www.udemy.com/user/manish-kac... #qlik #qliksense #qlikview #qs #qv #qlikdatamodel #qlikscript #set #let #setvariable #letvariable #variable #newtoqlik #newtoqliksense #newtoqs #newtoqlikview #newtoqv #learnqlik #beginnerqlik #trace #tracestatement #debug #Trace #tablefunctions #qlikfunctions #qlik #fieldname #fieldnumber #nooffields #noofrows #nooftables #qvd #storeqvd #createqvd #addyears #addmonths #date #time #dateandtimefunctions #monthstart #monthend #yearstart #yearend #pick #match #customisedreport #pivottable #networkdays #Genericload #fieldvaluecount #fieldvalue #tablename #loop #forloop #variableswithparameter #aggr #firstsortedvalue #Textbetween #FileList #AutoNumber