Discussion Board for collaboration on QlikView Scripting.
I've this script
LOAD KeyField, Field12, Field13, Field14 ..
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
LOAD KeyField, 'Yes' as NewField
(In Table2 LOAD) Applymap('Map', KeyField, 'No) as NewField
Is there any easy way, a function or a smart way to do it ?
LOAD KeyField, Field22, Field23, Field24 ..,If(Exists(KeyField),'Present','Not P') As Flag...
View solution in original post
LOAD KeyField, Field22, Field23, Field24 ,Yes as Flag
where exists (KeyField)
LOAD KeyField, Field22, Field23, Field24 ,No as Flag
where not exists (KeyField)
Thank you anbu1984 it works fine.