Qlik_038 : Mapping Load in Qlik Script : ApplyMap('Map_Table_Name', FieldName [ ,Default Mapping])
In this video, we will see
1) What is Mapping Load and Syntax of Mapping Load? (00:00:01 – 00:00:40)
2) Things to know before using Mapping Load. (00:00:41 - 00:01:18)
3) Mapping Load and ApplyMap example (00:01:19 – 00:05:23)
4) ApplyMap first parameter (00:05:24 – 00:05:31)
5) ApplyMap second parameter (00:05:32 – 00:06:45)
6) ApplyMap third parameter (00:06:46 – 00:07:45)
7) What will happen when we have duplicate values in Mapping Table? (00:07:46 – 00:09:50)
8) What will happen when we don’t use third parameter in ApplyMap? (00:09:51 – 00:11:03)
If you want to read on Mapping Load from Qlik help, use below link.
https://help.qlik.com/en-US/sense/Feb...
If you want to read Henric Constrom’s blog post on Mapping Load, use below link.
https://community.qlik.com/t5/Qlik-De...
Download data file and qvf for this video from below link.
https://drive.google.com/file/d/1hGgQ...
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 #sql #sqlconnection #sqldataconnection #forloop #foreachloop #qvd #createqvd #aggregation #Total #MappingLoad #ApplyMap