topic Re: Joing two fields in load script in QlikView

Joing two fields in load script

Tue, 22 Oct 2013 08:03:27 GMT

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

Tue, 22 Oct 2013 08:07:27 GMT

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 — Tue, 22 Oct 2013 08:08:52 GMT

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