topic Re: Mark lines what doesn't exists in another table in QlikView

Mark lines what doesn't exists in another table

ignacioroman — Sat, 16 Nov 2024 18:43:13 GMT

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:

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.

Re: Mark lines what doesn't exists in another table

Taoufiq_Zarra — Tue, 28 Apr 2020 22:49:00 GMT

can you share a sample data ?

Re: Mark lines what doesn't exists in another table

Saravanan_Desingh — Wed, 29 Apr 2020 02:10:42 GMT

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 ];

Re: Mark lines what doesn't exists in another table

ignacioroman — Wed, 29 Apr 2020 02:14:15 GMT

added!