Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
When I am trying to map a table, it is only converting the label/column title and not the data in the fields below? has anyone seen this issue before?
Thanks
Is it possible to share a small sample file?
can give you the general template:
MAPPINGTABLE:
MAPPING LOAD
'existing'
'desired'
FROM 'file.xls'
(biff, embedded labels, table is [sheet1$]
Rename FIELDS USING MAPPINGTABLE;
Do I need to use applymap?
I don't really understand where to put the function though, as it seems to not work on the correct table
check your spelling /case sensetive . That is usually the issue.
I am not sure what exactly you are trying to do based on the sample you provided. Have you taken a look at the help. In help you have examples, so that you can understand better,
You have correctly created the mapping table. The particular way you are using the mapping table:
Rename FIELDS USING MAPPINGTABLE
will rename field names, it does not change field contents.
If you want to change the contents (values) of a field, use either the MAP statement or the ApplyMap function.
For example, to change the map value in the Customer field:
MAP Customer USING MAPPINGTABLE;
Place the MAP statement in the script before the Customer table is loaded.
To map values as they are loaded, use the ApplyMap() function in a load statement.
LOAD
id,
City,
ApplyMap('MAPPINGTABLE', Customer) as Customer
FROM xyz.xls....
-Rob