Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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.

Tags (3)
1 Solution

Accepted Solutions

Re: Need help in creating a new field

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

2 Replies

Re: Need help in creating a new field

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

Not applicable

Re: Need help in creating a new field

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.

Community Browser