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