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
In order to have your tables related, you will need to rename PO_REF_NUMBER or ORDER_NO.
PO_REF_NUMBER AS ORDER_NO
QlikView only relates tables via field name.
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.
Retrieving data ...