Using NESTED IFERROR formula in Alteryx

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!

sample-iferror.xlsx

Datasets

Accepted answers

Bren_Spill2

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

Nested Regex.PNG

Nested Formula.yxzp

All comments

Luke_C

Hi @dtrix

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

New Workflow2.yxmd

Bren_Spill2

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

Nested Regex.PNG

Nested Formula.yxzp

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.

Dynamic Replace Example.yxmd

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:

Screenshot 2024-03-08 145502.png

Datacleanse.yxmd

dtrix

Thanks!!

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335