Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need a help on a data load in Qlik Sense Desktop.
I have two data tables which I need to connect by two values Transaction type and Document ID so that I might analyse data in a Qlic Sense. there is no other way bacause only these two vales identyfing records between those tables.
Is there any way on a data load to do that?
Thanks in advance.
Vidas Rojus
In Script:
Load
[Transaction Type]&' - '&[Docuemnt ID] as Composite_Key
Create a Join Key as
[Transaction Type]&' | '&[Docuemnt ID] as Key
in both table table and Comment on these two fields in any one table
Hi Vidas,
Simple join will do the work:
Table2:
load
*
from
Table2Source.qvd
(qvd);
left join (Table2)
load
*
from
Table1Source.qvd
(qvd);
Qlik engine joins information based on the fields' names so it will recognise key fields automatically.
Best regards,
Janusz
In Script:
Load
[Transaction Type]&' - '&[Docuemnt ID] as Composite_Key
Hi Vidas,
Strictly speaking you can just load the two tables you described above and Qlik Sense will take care of creating a 'synthetic key' to join the tables correctly. Often users will manually create a composite key to eliminate the synthetic key as described by Saumya and Manish in order to keep the data model clean and efficient.
-Josh
Qlik