Check matching data from two different tables with different field names

[Bharathi09]

Hi,

I need to check if data in one field of one table is matching with data in one field in other table

Both the field names are different 

Please help

Thanks

[Bharathi09]

I need to write logic like if code1 value exists in code2 load code1 value otherwise 'na'

please help me with logic

[MarcoWedel]

Can you show how you already tried yourself to write an expression using the exists() function?

[Bharathi09]

Yes,

tabledata:
load code2 as code1
resident Table2
Where Exists(code1,code2);

correct me if I am wrong

[MarcoWedel · Accepted solution]

for " ...  if code1 value exists in code2 ... " it would rather be 

Exists(code2,code1)

You could use this expression not only to restrict your load statement in the where clause but also as condition in an If() function that generates your desired code field.