Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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.
ID Name
1 John
2 Eli
3 Mark
4 Robert
Excel sheet to map:
Name | Place |
John | USA |
Eli | London |
Mark | Paris |
Robert | India |
So, in QlikView frint end, when i select ID 1, i can see place USA.
Can someone help..
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
MapName2Place:
mapping load
Name,
Place
from yoursource
TableIDName:
load
ID,
applymap('MapName2Place', Name,'NN') as whateryouwant
from pothresource
but even that you donot Need
a simple join what doit also
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
MapName2Place:
mapping load
Name,
Place
from yoursource
TableIDName:
load
ID,
applymap('MapName2Place', Name,'NN') as whateryouwant
from pothresource
but even that you donot Need
a simple join what doit also
Hi,
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)
mapping load
Name,
Place
from yoursource
TableIDName: - (qvd in app)
load
ID,
applymap('MapName2Place', Name,'NN') as whateryouwant
from pothresource
'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)
Thanq Rudolf