IFERROR Excel formula in Alteryx?

[Julie_Clarke]

Hi, can anyone advise me about how do I convert this Excel formula in Alteryx?

IFERROR(IF(SEARCH(AAA],[BBB],1),"Y","N"),"N")

[ShankerV]

Hi @Julie_Clarke 

Can you brief me with an example, what this formula does with your sample input.

What is the expected output also please.

Will be able to convert into Alteryx workflow easily.

Many thanks

Shanker V

[binuacs · Accepted solution]

@Julie_Clarke The Contains() formula should work 

IF(Contains([BBB],[AAA],’Y’,’N’)

note that this function doesn’t have the option to specify the search position like SEARCH function, 

[Julie_Clarke]

Thanks - is there an alternative function in Alteryx??

[binuacs]

@Julie_Clarke No built in functions available but this can be achieved with the help of some existing formulas, let me know if you want to building something like that

[Julie_Clarke]

Hi, 

Thanks for the offer, any help would be much appreciated.  Like many other things in Alteryx I imagine there are various approaches that can be taken and a view from a more experienced user would be great.

[EdwardCochrane]

Can you accomplish this just using an if contains statement?

If an error in excel would return nothing in alteryx then you could have something like 'elseif contains.... then "ERROR" ' or elseif contains([XYZ], "") then "ERROR".