Multiple data source and tables and same columns names
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?
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
Hope this resolve your issue. If the issue is solved please mark the answer with Accept as Solution & like it. If you want to go quickly, go alone. If you want to go far, go together.
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
Hope this resolve your issue. If the issue is solved please mark the answer with Accept as Solution & like it. If you want to go quickly, go alone. If you want to go far, go together.
