Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All Expert,
Can mapping table suport partial mapping?
Take an example:
RecordTb:
mapping load * Inline
[City,Name
'BJ*','BJ'
'Beijing','BJ'
];
map Locale using RecordTb;
load * Inline
[Locale
"BJ123"
"BJ12345"
"Beijing"
];
What I want to get is: I want to the Locale whose first 2 letters with BJ can be replaced by BJ.
How to achieve it?
Thanks.
Use Rob Wunderlich's wildcard mapping from his Qlikview Cookbook or Qlikview Components library.
Use Rob Wunderlich's wildcard mapping from his Qlikview Cookbook or Qlikview Components library.