Compare two fields

[#1]

I would like to compare two fields within a table.

example:

Bring field only when X equals Y

[ryanhicks · Accepted solution]

That is doable.

if(Fieldx =FieldY, Field C) as Field C

this will only load Field C if X =Y. 

If they don't equal, the value will be null.

[gajapathy74]

hi,

BirthAddress:

LOAD

          BirthAddress

Resident

          UserAddress

Where BirthAddress=PresentAddress;

not sure is this your requirement.

[#4]

Thanks, it really worked