Unwanted table merge on data import

[Ben]

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? 

[igdrazil]

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]

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]

Load * from table 1;

NoConcatenate

Load * from table 2;

just use "NoConcatenate" keyword in between.

[passionate]

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]

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]

Yes