topic Need help in QlikView

Need help

marwen_garwachi — Tue, 13 May 2014 18:27:43 GMT

Hello,

How can i do to identify the values existing in both table A and Table B without joining them by creating new column in table B (if value exist in table A then 1 else 0 ) ?

Thanks for your help

Re: Need help

Anonymous — Tue, 13 May 2014 18:40:37 GMT

Maybe this is what you want (your French version is clearer):

LOAD * INLINE [

Dossier_ID

];

LOAD

Dossier_ID,

if(exists(Dossier_ID), 1,0) as "B Exists in A"

INLINE [

Dossier_ID

];

Re: Need help

Tue, 13 May 2014 18:47:33 GMT

you can try this......

Re: Need help

maxgro — Tue, 13 May 2014 19:06:43 GMT

another one

in bold the differerence with previous answer

MAP:

mapping load Dossier_ID, 1 as flag;

LOAD * INLINE [

Dossier_ID

];

LOAD

Dossier_ID,

ApplyMap('MAP', Dossier_ID, 0) as "B Exists in A"

INLINE [

Dossier_ID

];

Re: Need help

marwen_garwachi — Wed, 14 May 2014 10:12:42 GMT

Thanks a lot it works !

Re: Need help

marwen_garwachi — Wed, 14 May 2014 10:14:04 GMT

Thanks a lot that's exactly what i need !