Qlik_029: How Generic Load works in Qlik. Dynamically combine all tables created using Generic load.

Опубликовано: 29 Сентябрь 2024
на канале: Manish Kachhia
3,451
54

In this video, we will see

1) What is Generic Load.
2) How to create Generic Tables.
3) How to dynamically combine all tables created using Generic prefix.

00:00:00 – 00:01:30 Introduction
00:01:31 – 00:03:20 Create Generic Load tables
00:03:21 – 00:07:35 Join all Generic tables by Left join (Static way)
00:07:36 – 00:15:20 Join all Generic tables by Left join (Dynamic Way)

If you want to read about Generic Load from Qlik help
https://help.qlik.com/en-US/sense/Feb...

Henric Cronstrom blog on Generic Load from Qlik Community
https://community.qlik.com/t5/Qlik-De...

Download qvf and data file for this video
https://drive.google.com/file/d/1-OAJ...

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