Need help

[marwen_garwachi]

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

[Anonymous · Accepted solution]

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

A:

LOAD * INLINE [

  Dossier_ID

    1

    2

    3

    4

    5

    6

];

B:

LOAD

     Dossier_ID,

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

INLINE [

  Dossier_ID

    1

    5

    10

    11

    12

    13

];

[#3]

you can try this......

[maxgro]

another one

in bold the differerence with previous answer

MAP:

mapping load Dossier_ID, 1 as flag;

LOAD * INLINE [

  Dossier_ID

    1

    2

    3

    4

    5

    6

];

B:

LOAD

     Dossier_ID,

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

INLINE [

  Dossier_ID

    1

    5

    10

    11

    11

    12

    13

];

[marwen_garwachi]

Thanks a lot it works !

[marwen_garwachi]

Thanks a lot that's exactly what i need !