I understood that you have a field with a 7 digit number, but only the first 6 are significant for your lookup.
So I suggest that you look only at your first 6 digits and look those up in your mapping table.
I quite don't understand when you are saying:
Need applymap('mytable', left(FIELD,7) ) and that's why I need 0-9 on every possible 6-digit number.
or why my suggestion should not solve your problem. Could you maybe give an example where my suggested code doesn't give you the expected result?
It looks to me like Stefan's suggestion works in this case. However, if you need full wildcard mapping, see the QV Cookbook (http://robwunderlich.com/downloads/) example "Mapping with a table using wildcards" or easier still use the Qlikview Components (http://qlikviewcomponents.org) function "Qvc.CreateWildMapExpression".
Is this solution (createwildmap OR the Cookbook - they appear to be the same thing as per the script) working in QV11?
I get an error on the first line, seems like there's something missing. I tried removing the ( ' ) before 'pick' but that leads to many more syntax checks.
Can you please guide. Appreciate all your help.
If I understand you maybe this can help you:
LOAD '|' & QLKRTP as QLKRTP_Map, QLDESC_OWN as QLDESC_OWN_Map INLINE [
426388,Dolor sit amet
LOAD purgechar(mapsubstring('map_table','|' & ID),'0123456789') as MappedField, * INLINE [