Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Ross1991
Contributor III
Contributor III

Table being combined when Uploaded

How do I keep two tables separately when uploaded?  Each table is a separate Excel file (Feb.xls and March.xls).  Row heading and columns are the same on both files except data are different (production numbers).  I created a new App.  Then uploaded two separate files.  But both gets combined into one table once uploaded.  Instead of seeing two Bubbles, I see one Bubble in Data manager (as shown below). I would like to see each table separately with two Bubbles in a Data Manager. One for Feb and one for March.  Thank you.   

Ross1991_0-1714508933653.png

 

 

Labels (1)
1 Solution

Accepted Solutions
BrunPierre
Partner - Master II
Partner - Master II


Feb:
LOAD * FROM Feb.xls;

NoConcatenate

March:
LOAD * FROM March.xls;

NoConcatenate is a script statement you manually add between the two LOAD statements in the script editor/Data load editor.

View solution in original post

5 Replies
BrunPierre
Partner - Master II
Partner - Master II

If the field names and the number of fields in multiple loaded tables are identical, Qlik will automatically merge their content into a single table through automatic concatenation.

However, this can be prevent by using a "NoConcatenate" statement.

Feb:
LOAD * FROM Feb.xls;

NoConcatenate

March:
LOAD * FROM March.xls;

Ross1991
Contributor III
Contributor III
Author

Can you please tell me where do I find No Concatenate Button?  I loaded Feb.xls.  Looking for No Concatenate, before loading March.xls.  Thanks.

BrunPierre
Partner - Master II
Partner - Master II


Feb:
LOAD * FROM Feb.xls;

NoConcatenate

March:
LOAD * FROM March.xls;

NoConcatenate is a script statement you manually add between the two LOAD statements in the script editor/Data load editor.

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

A related question. Why do you want to keep these tables separate? If we understood that maybe we could offer some other suggestions. 

-Rob

Ross1991
Contributor III
Contributor III
Author

Thanks to @BrunPierre for replying.   I got it.  I also discovered how to split table by clicking on Split Table icon in data manager without having to write a statement.  It is on pull down button on button "Associations".  @rwunderlich I am very new to Qlik Sense (less than a month to be exact), so I have not fully comprehend the advantage and disadvantage of  joined or separate tables.  Once I was able to make a separate tables, now I realize, it may not work for my application.  At least now I know how to do it.  Looking forward to learn a lot from you all experts out there.   Thank you again.