Left join with renamed field

[jessica_webb]

I have a table of data in my script called 'TABLE_DATA'. In there, is a field called 'Key'

I would like to Left Join another table of date which has two fields, one of which which matches 'Key' but is called 'Type' in the original data file.

I am using the following in the script:

LEFT JOIN (TABLE_DATA)

LOAD Type as Key,

Points as New points

FROM....

But this doesn't work. Why not?

If I go into my original data file and change field name 'Type' to 'Key', then it joins perfectly - but I don't want to have to do that, I want to do it in the script.

Anyone know where I'm going wrong?

Thanks,
Jess

[fvelascog72]

Hi,

Have you tried rename Key for Type in the first table?

Saludos.

[jessica_webb · Accepted solution]

I haven't, but don't really want to rename that field... But thank you for the suggestion.

However, my original script now seems to be working - not sure what happened there, but will close this thread as I no longer have a problem