Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
In the load script, I have a nested applymap running. I have multiple tables, where the output i have to return is the same, but the mapping key will change. Hence nested applymap.
However, now I need to do approximate matches. For example, map ID in my table will be "abc xyz pvt ltd" and other mapping tables might have it as "ABC XYZ MGT" or "ABC" something like that. Basically I need wildcards where I can map using ABC* or something. Can you please help me on how this can be done in Qlikview?
Thanks
Probably have a look at this wonderful post by @rwunderlich