I am familiar with the functions.
My problem is the data example provided is taking from a load from a colleague and I wish to translate this (in bulk, as there are 60k+ rows) into multiple applymaps.
1 for country, 1 for car make and so on.
I hope this is more information.
I thought do loop and while iter() would be useful but i am getting no luck.
May be this:
LOAD * INLINE [
Mapping Table, Raw code, New Value
Country, a, UK
Country, b, USA
Country, c, IRE
Car Make, 1, Fiat
Car Make, 2, Ford
Car Make, 3, Ferrari
FOR i = 1 to FieldValueCount('Mapping Table')
LET vField = FieldValue('Mapping Table', $(i));
LOAD [Raw code],
Where [Mapping Table] = '$(vField)';
DROP Table Table;