Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
jamesmf1982
Contributor III
Contributor III

Additional table links after a binary load

Hi there, 

Hoping for some advice to see if something is possible. We are creating Qlik reports based an a schema that has been given to us by our software company, but using the binary load in our script. All data is in there, however there are certain paths that whilst they have unique references between them are not possible to get. For instance a client table will have a ClientID which links into another table for their visits. However on the other side their client ID relates to a Setting they live at. What is not possible at the moment is to get the information from the Setting to be visible with the visits. 

My question is, is it possible to have a new link after the load to create a new table to link this information?

1 Solution

Accepted Solutions
JuanGerardo
Partner
Partner

Hi @jamesmf1982, yes it is possible. After the binary load, you can follow with more transformations in your script, so you can load new tables from the existing ones and drop tables. The binary load is just a start point, although usually is used as end point.

JG

View solution in original post

2 Replies
JuanGerardo
Partner
Partner

Hi @jamesmf1982, yes it is possible. After the binary load, you can follow with more transformations in your script, so you can load new tables from the existing ones and drop tables. The binary load is just a start point, although usually is used as end point.

JG

View solution in original post

jamesmf1982
Contributor III
Contributor III
Author

Brilliant! Thanks for that, I'll have a play around 🙂