Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Joing two fields in load script

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?

script.JPG.jpg
Appreciate any feedback.  thanks

2 Replies
Not applicable

Re: Joing two fields in load script

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
Contributor III

Re: Joing two fields in load script

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

Community Browser