This content has been marked as final. Show 3 replies
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 ?