Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
IMPORTANT: Upcoming LEF Database Maintenance, Oct. 3rd - SEE DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
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
Highlighted
Contributor II
Contributor II

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?

 

Highlighted
Specialist
Specialist

Load * from table 1;

NoConcatenate

Load * from table 2;

just use "NoConcatenate" keyword in between.

Highlighted
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.

Highlighted
Contributor II
Contributor II

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? 

Highlighted
Specialist
Specialist

Yes