Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to import some data from Azure. I want 3 tables from the dataset where two of them happen to have identical column names. This causes Qlik Sense to automatically merge the two after I press the import button.
1. How do I prevent this from happening?
2. I can see the table has a small perentesis "2 sources", so it seems Qlik remembers that it merged the tables. How do un-merge the tables after they have been auto-merged?
The two tables become one "bubble" in the data tab.
There was only one set of column headers so I think it just added all rows from both tables into one table.
I am just importing via the graphical interface, how do I do a Noconcatenate load?
Load * from table 1;
NoConcatenate
Load * from table 2;
just use "NoConcatenate" keyword in between.
You get Auto generated script in Qliksense script when you use graphical input rather than script editor.
you can go ahead and change that script in Auto generated section.
I am just using the graphical interface, I have not used any loading scripts.
Is it necessary to use loading scripts to avoid automatic merging of column equivalent tables?