Joing two fields in load script

[#1]

Hi team

Can someone please explain how I can join ORDER_NO to PO_REF_NUMBER based on the below.  What do I need to put into the script to make that work?

Appreciate any feedback.  thanks

[#2]

Hi Chris,

In order to have your tables related, you will need to rename PO_REF_NUMBER or ORDER_NO.

Example:

LOAD

     INVOICE_ID,

     ITEM_ID,

     REFERENCE,

     PO_REF_NUMBER AS ORDER_NO

FROM XXX

QlikView only relates tables via field name.

[advait_thakur]

Hello Chirs,

In your script just add

PO_REF_NUMBER as ORDER_NO

I am not sure what results are you expecting but this is the way to join if you wish to join forcefully.

Thank You

Advait