Why two same tables data got concatenated?

Anonymous — Sat, 16 Nov 2024 05:12:42 GMT

Hi All,

I am very new to qlik. In qlikview Why two same tables data got concatenated even i have given with two different table names.

For example

Customer:

CustId,CustName
1,A
2,B

Sample:
CustId,CustName
3,C
4,D

Output coming only one table with two tables of data .I know both the tables fields are same but i given the two different table names that's why iam confusing .Can anybody please explain me why qlikview behaves like that.what happens internally when two table fields are same .

Thanks & Regards

seenu.

Re: Why two same tables data got concatenated?

Anil_Babu_Samineni — Tue, 20 Nov 2018 23:32:44 GMT

Qlik do auto concatenate as you have same fields from different table? You can try

Customer:

Load CustId,CustName,'T1' as Flag From Table1;

Sample:
Load CustId,CustName, 'T2' as Flag From Table2;

Customer:

Load CustId,CustName From Table1;

NoConcatenate

Sample:
Load CustId,CustName From Table2;

topic Why two same tables data got concatenated? in QlikView

Why two same tables data got concatenated?

Re: Why two same tables data got concatenated?