topic LOAD + IF to other table in QlikView

LOAD + IF to other table

Joaquin_Lazaro — Fri, 24 Apr 2015 07:42:19 GMT

Hello:

I've this script

Table1:

LOAD KeyField, Field12, Field13, Field14 ..

Table2:

LOAD KeyField, Field22, Field23, Field24 ..

I need to create a new boolean field calculated (NewField) on Table2 thats indicates if KeyField is or not in Table1.

I've thought in a mapping table created from resident Table1 and an applymap in Table2 LOAD instruction

Map:

MAPPING

LOAD KeyField, 'Yes' as NewField

Resident Table1

(In Table2 LOAD) Applymap('Map', KeyField, 'No) as NewField

Is there any easy way, a function or a smart way to do it ?

Thank you

Joaquín

anbu1984 — Fri, 24 Apr 2015 07:47:21 GMT

Table1:

LOAD KeyField, Field12, Field13, Field14 ..

Table2:

LOAD KeyField, Field22, Field23, Field24 ..,If(Exists(KeyField),'Present','Not P') As Flag...

ankitaag — Fri, 24 Apr 2015 08:09:28 GMT

Table1:

LOAD KeyField, Field12, Field13, Field14 ..

Table2:

LOAD KeyField, Field22, Field23, Field24 ,Yes as Flag

where exists (KeyField)

concatenate

Table3:

LOAD KeyField, Field22, Field23, Field24 ,No as Flag

where not exists (KeyField)

Joaquin_Lazaro — Fri, 24 Apr 2015 08:23:47 GMT

Thank you anbu1984 it works fine.