Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
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.