Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have 2 tables.
Table 1:
Table 2:
And I need create a qlikview's table like this:
Anyone help me?
MapCodDesc:
mapping load
Cod, Description
from ...table2source...;
Result:
load Level, Code, Value, applymap('MapCodDesc',Cod) as Description
from ...table1source...;
MapCodDesc:
mapping load
Cod, Description
from ...table2source...;
Result:
load Level, Code, Value, applymap('MapCodDesc',Cod) as Description
from ...table1source...;
Use applymap ()
This video may help
https://www.youtube.com/watch?v=jby-omVFNzI&feature=youtube_gdata_player