Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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