Multiple data source and tables and same columns names

[rammiee93]

I have tables from multiple sources but same column names. When I do any visualization though I filtered the  fields with the table, I still see the other values from the other table with same column names.

Any way to select on the values from specific table? 

@Kushal_Chawda 

[vikasmahajan · Accepted solution]

Hi,

While concatenating you can define type as table identifier in qlik sense. Please following example

Data

Load 

   col1,col2,col3, 'TableA' as Type  from Table A

Concatenate 

Load 

   col1,col2,col3, 'TableB' as Type  from Table B

..

etc

And use Type field to identify the fields from either table A or Table B.

Hope this resolve your issues.

Vikas