topic Re: Need help in creating a new field in QlikView

Need help in creating a new field

Thu, 18 Apr 2013 11:15:35 GMT

Hi all,

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.

Regards,

Amay.

kaushiknsolanki — Thu, 18 Apr 2013 12:56:51 GMT

Hi,

Try this.

T1:
Load * inline [
F1, F2
a, a
a, b
a, c
b, a
b, d
b, e
];

join

load F2,F2 as F3 Resident T1 where not Exists(F1,F2);

Regards,

Kaushik Solanki

Thu, 18 Apr 2013 13:23:24 GMT

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.