Possibly you are struggling to get the distinct values from ONLY the second table. Since the load is causing auto concatenate, the DISTINCT is being applicabe for both the table here. To achieve the same, you have to avoid autoconcatenate and use force concatenate like below:
As tresco Explained. Since the load is causing auto concatenate, the DISTINCT is being applicable for both the table here. To achieve the same, you have to avoid auto concatenate and use force concatenate like below:
That is why he use force concatenation. but with 1 extra field.
As QlikView is in memory tool it loads everything in memory.
Then I use below code to eleminate the extra filed.
drop table T1
here NoConcatenate will not concatenate the above earlier loaded data in memory.
If we don't drop table above then there will be chances of data duplication.