need a table for the data in the resultant table inqlikview

[Anonymous]

hi i have two data sets with same column names so when i have loaded they have joined automatically in to a single table but i need to know the data in that table belongs to table1 or table2 ..so i need a column in the resultant table showing table1 or table2 for the data...in qlikview

[krishnacbe]

Hi,

Try below

Load *,

'Table1' as TableName;

SQL Select * from Tablename;

Load *,

'Table2' as TableName;

SQL Select * from Tablename;

with the TableName  field you can identify the source table.