Why two same tables data got concatenated?

[Anonymous]

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.

[Anil_Babu_Samineni]

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;

Or

Customer:

Load CustId,CustName From Table1;

NoConcatenate

Sample:
Load CustId,CustName From Table2;