Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Using NESTED IFERROR formula in Alteryx

dtrix
7 - Meteor

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!

 

 

 

6 REPLIES 6
Luke_C
17 - Castor

Hi @dtrix 

 

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

image.png

Bren_Spill
12 - Quasar

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

 

Nested Regex.PNG

SPetrie
12 - Quasar

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.

replace.PNG

dtrix
7 - Meteor

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
12 - Quasar

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

 

Screenshot 2024-03-08 145502.png

 

dtrix
7 - Meteor

Thanks!!

Labels