Discussion Board for collaboration on QlikView Scripting.
I'm a begineer in QlikView.
I have gone thorugh videos of Mapping load tutorials but everything confused me.
I have a QVW file where i have ID and Name.
I wanna map the Name to a place from Excel sheet.
Excel sheet to map:
So, in QlikView frint end, when i select ID 1, i can see place USA.
Can someone help..
Go to Solution.
you talk about mapping load, but what you want you donot Need it
in Frontend you define listbox with Name and you define a table with ID and Place
the datamodel automatically connects the two tables by the same fieldname (=Name).
so you select ID = 1, the table reduces to 1 row with ID=1 and Place=USA
if you want to know how mapping works:
you Need following steps in script
define mapping table
applymap('MapName2Place', Name,'NN') as whateryouwant
but even that you donot Need
a simple join what doit also
There were hundereds lines and the ID which i referred to might be repeating.
I wanna do it by mapping it in script load.
syntax mentioned by you is i assume:
I was not understanding 'NN' ???
MapName2Place: - (Excel sheet)
TableIDName: - (qvd in app)
'NN' means when an ID receives the mapping table which was not loaded you will get 'NN'
if you are sure, that you have all distinct values , then you donot Need 'NN' (skip it)