Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

vb00494773
New Contributor III

Help me to get a the below answer

Hi Everyone,

Please help me to get below answer

example tables :

table 1:

 

id value
1100
2

200

table 2:

 

id value
150
1100
2200
3150
3200
4250
4300
4350

output:

 

id value
3150
3200
4250
4300
4350

i have used where not Exists , i am getting one value for each id (it is giving unique values )

My case i want all the values as like output.

Can you suggest me something.

Thanks

1 Solution

Accepted Solutions

Re: Help me to get a the below answer

T1:

Load id as ID, value as VALUE Inline

[

id, value

1,100

2,200

];


NoConcatenate

T2:

Load * Inline

[

id, value

1,50

1,100

2,200

3,150

3,200

4,250

4,300

4,350

] Where Not Exists(ID,id);


Drop Table T1;

8 Replies
Digvijay_Singh
Honored Contributor III

Re: Help me to get a the below answer

Try like this -

[table 1]:

Load *,id as tempid inline [

id, value

1, 100

2, 200 ];


[table 2]:

Load * inline [

id, value

1 ,50

1, 100

2,200

3, 150

3 ,200

4, 250

4, 300

4 ,350 ]

Where not exists (tempid,id);


Drop field tempid;


drop table [table 1];

Re: Help me to get a the below answer

T1:

Load id as ID, value as VALUE Inline

[

id, value

1,100

2,200

];


NoConcatenate

T2:

Load * Inline

[

id, value

1,50

1,100

2,200

3,150

3,200

4,250

4,300

4,350

] Where Not Exists(ID,id);


Drop Table T1;

vb00494773
New Contributor III

Re: Help me to get a the below answer

Thanks for the reply,

This will not work in my case , if you see i don't want get id (1,2) and their values into my output table.

Thanks

Re: Help me to get a the below answer

Have you tried ?

vb00494773
New Contributor III

Re: Help me to get a the below answer

Hi Manish ,

Thanks it worked.

Digvijay_Singh
Honored Contributor III

Re: Help me to get a the below answer

You won't get id = 1,2

vb00494773
New Contributor III

Re: Help me to get a the below answer

Yes, you are right , typo from my side .

Thanks

Re: Help me to get a the below answer

Community Browser