Need help in creating a new field

[#1]

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

F1	F2
a	a
a	b
a	c
b	a
b	d
b	e

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

F3
c
d
e

And table box should be like below table

F1	F2	F3
a	a	-
a	b	-
a	c	c
b	a	-
b	d	d
b	e	e

Let me know for any other details.

Thanks in advance.

Regards,

Amay.

[kaushiknsolanki · Accepted solution]

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

[#3]

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.