Discussion Board for collaboration related to QlikView App Development.
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)
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.
LOAD *,1 INLINE [
LOAD *, ApplyMap('Mapper',a,0) As d INLINE [
a, b, c
5, b1, c1
10, b2, c2
Messi, b3, c3
21, b4, c4
View solution in original post
can you share a sample data ?