A Simple Scripting Question

[#1]

Hi,

While loading the data from a file I have renamed certain fields into common names ( as AGENT_CODE as CODE). Now in case I further want to do some further modifications in the script with the renamed fields, do I need to use the original field name ( AGENT_CODE ) or can I use the new name ( CODE)?

Thanks for the help

[#2]

hi,

u can modify ur code like this

tab1:

LOAD
AGENT_CODE as Code,
AGENT_NAME as Name,
AGENT_AGE as Age
FROM ABC.xlsx (ooxml, embedded labels, table is Sheet1);

left join (tab1) load *,Code&Age as Unique resident tab;

including * will create a link

thanks

[#3]

After you changed your code, have you reloaded the file?