I am familiar with power Bi but very new to QlikView and is currently struggling with a Client project. In power Bi we could duplicate/reference a data source. Does Qlik have a similar functionality or in other words is it possible to perform the same in QLIk.
I tried loading the same data source twice through the data load manager, but it seems to keep overwriting the previous import. Any help is much appreciated.
When two or more loaded tables have exactly the same field names and the number of fields, the data from each LOAD or SELECT statement is automatically merged into one table. I believe you're experiencing this, to prevent this, you must explicitly use the NoConcatenate statement between the tables.
Table1: LOAD a, b, c FROM table1.csv;
NoConcatenate Table2: LOAD a, b, c FROM table2.csv;
Thank you for the response. I will def try this. Also, is there any YouTube or Qlik tutorial which you would recommend to refer for learning how to load data through the data load editor?
I am currently using the data manager to add the data.
