Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
];
can you share a sample data ?
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
];
added!