What tool can i used to convert one value to another

[jaemilao]

Hi,

I have a value of "ABS" under my last column, and i want to convert the value of "ABS" to "Bond" instead. Should i use a formula with If statement? trying to draft the formula but not having any luck,

Thank you for your help

[IraWatt · Accepted solution]

Hey @jaemilao,

Yes a formula is perfect for this use case. A formula like this works:

IF [Instrument type] = "ABS" THEN "Bond" ELSE [Instrument type] ENDIF

The community has some quick and easy videos on formulas and the Formula Tool here https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Writing%20...

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com 

[chukleswk · Accepted solution]

You'll want to use the formula tool and the statement should look like:

if [Right_instrument_type] = 'ABS' Then 'Bond' else [Right_instrument_type] endif