Using NESTED IFERROR formula in Alteryx

[dtrix]

Need help with converting this xls formula =IFERROR(IFERROR(IFERROR(IFERROR(LEFT([@[Program Name]],SEARCH("XOL",[@[Program Name]])-1),LEFT([@[Program Name]],SEARCH("XL",[@[Program Name]])-1)),LEFT([@[Program Name]],SEARCH("Excess",[@[Program Name]])-1)),LEFT([@[Program Name]],SEARCH("_",[@[Program Name]])-1)),"") to an alteryx one.

Attaching the xls file and the desired result with the above formula in it.

Thanks!

[Luke_C]

Hi @dtrix 

This isn't really a concept in Alteryx. You could use if statements to get the same answer:

[Bren_Spill · Accepted solution]

Hi @dtrix - the formula below should work for you. Workflow also attached

 

[SPetrie]

To put out another option, you can use a dynamic replace for this as well. It is a bit more involved in setup, but adding or removing items is much easier for larger lists of test cases.

[dtrix]

Thanks everyone for different sorts of solutions. Very very helpful
Since I am not familiar with Regex, I will try @Luke_C 's solution. Would you know how to make the Findstring functions case INsenstive because sometimes XOL is capital, sometime XoL?

[nagakavyasri]

@dtrix You can cleanse the data to standardized format before using the formula:

[dtrix]

Thanks!!