Additional table links after a binary load

[jamesmf1982]

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?

[JuanGerardo · Accepted solution]

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

[jamesmf1982]

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