Formula Help

[lac]

Hello,

I'm new to Alteryx and hoping someone can help me.

Trying to replace specific cells (not all) in a column with a different name than in source data but can't figure out the formula to do so. I want to leave all of the data not listed below, the same. Only looking to change these three.

Column heading is called = Structure

Current	New
EBE-Processing	EBE
EBE-Application	EBE
EBE-Implementation	EBE

Thank you!

[Thableaus · Accepted solution]

Hi @lac 

There are several ways to do that.

One is using Switch function, which works like a CASE Statement.

Or if you want more flexibility and less hardcoding, you could use Find and Replace Tool. 

Cheers,