Discussion Board for collaboration on QlikView Scripting.
I have a requirment, which I am not able to do it. Please help me in resolving the issue.
For example, I have two fields and have some values
I would like to create a new field F3 such that when F2 is compared with F1, no values of F1 should be present in F3
Output should be
And table box should be like below table
Let me know for any other details.
Thanks in advance.
Go to Solution.
T1:Load * inline [F1, F2 a, a a, b a, c b, a b, d b, e ];
load F2,F2 as F3 Resident T1 where not Exists(F1,F2);
Please check attached. Basically using where not exists and left join for this. There might be a better solution but this is a quick concept.