Updating cell values

[jeetamar11]

I need to replace Column1 value-based on specific combination of values in column 1 and column 2. Why the following formula is not working.

if [Transfer Work Basket]='FR Main-REC' and [Claim Reason]= 'Lost' then [Claim Reason] = 'Lost Recoverable' else [Claim Reason] endif

[alexnajm · Accepted solution]

I think you just need to remove a portion of it

if [Transfer Work Basket]='FR Main-REC' and [Claim Reason]= 'Lost' then [Claim Reason] = 'Lost Recoverable' else [Claim Reason] endif

[ChrisTX]

Do you have the actual text

then [Claim Reason] = 'Lost Recoverable' else [Claim Reason] endif

in your IF coding?

In Alteryx, you don't specify the field name after THEN.  In the Formula tool, the field name is specified in the drop-down for Select Column.

See  Formula Tool (alteryx.com)

Chris

[OTrieger]

@alexnajm  Yes you are right, the current formula will return 0.

[nagakavyasri · Accepted solution]

@jeetamar11 guess this is what you are looking for: