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: 
SudharshanK
Creator
Creator

Import Same table multiple times

I would like to import the same table two times into the Data Manager in QlikSense Cloud. However, when I try importing the same table multiple times from the same connection, Qlik replaces the previous table and does not create a copy in data manager. Is there any trick to import the same table multiple times so that copies of the same table are imported into the Data Manager?

Labels (1)
2 Replies
Sarchiz
Partner - Contributor II
Partner - Contributor II

Well it is not physically possible so , no, not really.

What is the use case for this ?

If you need the same data again, you can resident load it an it will concatenate to the initial data.

If you need it separately you could use qualify and maybe keep a common reference to join the tables.

Vegar
MVP
MVP

If you load the same data twice then the second load will autoconcatenate into the table created in the first load.

Example reading "Source" that contains 10 rows:

Data: Load FieldA, FieldB From Source; 

// You will now have a table named "Data" containing  10 rows

Data2: Load FieldA, FieldB From Source; 

// You will automatically concatenate  the second load into Data table as the two have exactly the same field name setup.

// You can override this by using 

Data2: NoConcatenate Load FieldA, FieldB From Source; 

//Note that you will synthetic keys that you should adress by renaming the field names to something unique for the new table.