Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
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.