Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Can you show how you already tried yourself to write an expression using the exists() function?
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.