About mapping

[#1]

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.

[Gysbert_Wassenaar · Accepted solution]

Use Rob Wunderlich's wildcard mapping from his Qlikview Cookbook or Qlikview Components library.