Qlik_038 : Mapping Load in Qlik Script : ApplyMap('Map_Table_Name', FieldName [ ,Default Mapping])
ฝัง
- เผยแพร่เมื่อ 20 ก.ย. 2024
- 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.
help.qlik.com/...
If you want to read Henric Constrom’s blog post on Mapping Load, use below link.
community.qlik...
Download data file and qvf for this video from below link.
drive.google.c...
You can also find me on
TH-cam: / @manishkumarkachhia1683
Facebook: www.facebook.c...
LinkedIn: / manishkachhia
Twitter: / mk_qsl
Udemy: www.udemy.com/...
#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