Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Qlik community,
Im adding my data using the qlik data load editor, and was wondering how to create an association between my tables
In the past i used do this using the graphical interface since i added tables using the data manager instead.
Any guidance is appreciated 😃
Thanks
Hi,
To make associations between two or more tables, you need a common field based on which those tables can be connected.
If you have those, all you have to do is make their name same and qlik will automatically associate them.
For example.
Table1:
Load F1,F2,F3 from xyz;
Table2:
Load F4 as F1,F5,F6 from abc;
Table3:
Load F7 as F5,F8,F9 from pqr;
Regards,
Kaushik Solanki
Hi,
To make associations between two or more tables, you need a common field based on which those tables can be connected.
If you have those, all you have to do is make their name same and qlik will automatically associate them.
For example.
Table1:
Load F1,F2,F3 from xyz;
Table2:
Load F4 as F1,F5,F6 from abc;
Table3:
Load F7 as F5,F8,F9 from pqr;
Regards,
Kaushik Solanki
Oh thanks, that sounds very simple
Ill try it out tomorrow and let you know
Much appreciated 😃