Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Ben
Contributor II
Contributor II

Unwanted table merge on data import

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? 

Labels (2)
6 Replies
igdrazil
Creator III
Creator III

Hi Ben,

what do you mean by merge? Does Qlik link the tables or does it concatenate them?

The ladder can be circumvented by adding a "Noconcatenate load ...".

Hope this helps!
Regards
Chris
Ben
Contributor II
Contributor II
Author

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?

 

passionate
Specialist
Specialist

Load * from table 1;

NoConcatenate

Load * from table 2;

just use "NoConcatenate" keyword in between.

passionate
Specialist
Specialist

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.

Ben
Contributor II
Contributor II
Author

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? 

passionate
Specialist
Specialist

Yes