Compare field.table1 with field RANGE in table2

[Anonymous]

Compare field.table1 with field RANGE in table2 in load script

example something like below but obviously the below doesn't work.

Bring field only when Table1 .FieldX exist in Table2.Field Y

if(Exists(Table2.FieldY,Table1.FieldX)=0,'Does not exist'),

[jonathandienst]

Exists() only works in script - it is not available in the front end expressions. Use the unqualified field names:

     If(Exists(FieldY, FieldX) = 0, 'Does not exist') As [XYExist],

[jyothish8807]

Hi Chantelle,

First bring both the fields in to same table using joins, then simply create a field in script.

load

if(field1=field2,field1) as New_field

from <>

Regards

KC