Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Need help in creating a new field

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

F1F2
aa
ab
ac
ba
bd
be

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

F1F2F3
aa-
ab-
acc
ba-
bdd
bee

Let me know for any other details.

Thanks in advance.

Regards,

Amay.

1 Solution

Accepted Solutions
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

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 remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

View solution in original post

2 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

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 remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Not applicable
Author

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.