Discussion board where members can get started with Qlik Sense.
I have a question: there are 2 Tables
The expected output is:
what is best way to exclude the values and still only D = 3
Thanks a lot
Go to Solution.
If using sunny example i added Noconcatenate because table need to not concatenate
Where not Exists(ID);
DROP Table Tab_B;
Is this needed during loading of the data? May be this
Do you need only data for D Column.
Load ID, Sales
where not exists(ID);
drop table Tab_B;
But why is that needed its.anandrjs? My Tab_B only have ID and Tab_A have ID and Sales. They are not going to auto concatenate. I don't think there is a need for NoConcatenate here. Would you agree?
Sunny Thanks a lot for your feedback and help
Martin Thanks a lot for your feedback and help
Anand Thanks a lot for your feedback and help
Because field names are same and they concatenated first, try below example and comment the Noconcatenate and rename the filed ID to some other name and see the result.
LOAD * Inline
]Where not Exists(IDD,ID);