topic Re: JOIN Problems in QlikView

JOIN Problems

aminehaddar — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have 2 tables:

ID	SEG	RESULT
		3
12	A	1
13	B	1
14	B	1

CLIENT_ID	MESURE
	1
13	1

I want to find as a result the difference between the 2 tables:

ID	SEG	RESULT
		3
12	A	1
14	B	1

Any help please?

Regards,

Re: JOIN Problems

olivierrobin — Wed, 04 Jul 2018 08:49:15 GMT

hello

what do you mean by difference ?

as I see, the keys are not the same in each table (ID,SEG for A, CLIENT_ID for B)

you could try a join on SEG=CLIENT_ID

and ion a 2nd pass create a flag if RESULT<>MESURE

Re: JOIN Problems

tresB — Wed, 04 Jul 2018 08:52:01 GMT

May be like:

Load * Inline [

CLIENT_ID, MESURE

13, 1];

Load * Inline [

ID, SEG,RESULT

, ,3

12, A, 1

13, B, 1

14, B, 1

] where not Exists(CLIENT_ID,ID) or len(trim(ID))=0;

Drop Table B;

Re: JOIN Problems

aminehaddar — Wed, 04 Jul 2018 08:52:19 GMT

Both have the same key, just when I wrote the exemple I made a mistake, Both have the same name : ID.

Regards

Re: JOIN Problems

olivierrobin — Wed, 04 Jul 2018 08:55:49 GMT

so you can join them using that key

tab:

load * from A;

join(tab)

load CLIENT_ID,MESURE

from B;

tab2:

load *,

if(RESULT<>MESURE,1,0) as flag_error

resident tab;

Re: JOIN Problems

niclaz79 — Wed, 04 Jul 2018 08:57:59 GMT

Loading Inline with a where-condition? Bold move.

Re: JOIN Problems

tresB — Wed, 04 Jul 2018 09:28:49 GMT

Inline data load is here for non-availability of actual data source and trying to give the OP an idea.