Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Live chat with experts, bring your API Integration questions. June 15th, 10 AM ET. REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
ignacioroman
Contributor II
Contributor II

Mark lines what doesn't exists in another table

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.

Labels (3)
1 Solution

Accepted Solutions
saran7de
Master
Master

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

commQV25.PNG

View solution in original post

3 Replies
Taoufiq_Zarra
Master II
Master II

can you share a sample data ?

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
saran7de
Master
Master

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

commQV25.PNG

View solution in original post

ignacioroman
Contributor II
Contributor II
Author

added!