topic Left join with renamed field in QlikView

Left join with renamed field

jessica_webb — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Left join with renamed field

fvelascog72 — Wed, 05 Jul 2017 07:47:31 GMT

Hi,

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

Saludos.

Re: Left join with renamed field

jessica_webb — Wed, 05 Jul 2017 07:53:53 GMT

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