Mark lines what doesn't exists in another table

[ignacioroman]

Hello everyone, 

I need execute an script with 2 tables. 

Table "A" has the variables a, b and c.

Table "B" has the variable a (the same as above)

I need get this table (if could be without a new table "resident", would be great)

Table:

a

b

c

d (d is an aux variable, =1 if "a" exist in the second table and =0 if "a" doesn't exist in the second table).

Could you help me? 

Edit: simple example attached. The Excel workbook contains 3 sheets, table 1, table 2 and expected table.

[Taoufiq_Zarra]

can you share a sample data ?

[Saravanan_Desingh · Accepted solution]

One solution using map.

Mapper:
Mapping
LOAD *,1 INLINE [
    a
    10
    Messi
];

tab1:
LOAD *, ApplyMap('Mapper',a,0) As d INLINE [
    a, b, c
    5, b1, c1
    10, b2, c2
    Messi, b3, c3
    21, b4, c4
];

[ignacioroman]

added!