"Contains" function not working

Question

Hi everybody,

After the latest Alteryx update, it seems like I have some problems with the filter tool and contains function. For the filter one, I don't have the example anymore, but it was something like [column1] - [column2] = 0, and in the true output, the difference was above 100 (both columns were doubles). I will try to re-create it and post is here.

I have also tried to make a formula to include all the checks, then apply a filter and put a data cleansing before the filter, but it still doesn't work. Any input is appreciated. Maybe it's something that I'm missing and an easy fix.

Sometimes after re-opening Alteryx, it works, but I can't automate something if I need to double-check everything after running the flow.

-> this is the filter

-> this is the false output

-> this is where I tried the formula

-> the false output

Thanks,

Roxana

IraWatt · Accepted Answer

Hey @RMojsiak,

I think you have you parameters the wrong way round, were you expecting Demo to be in the True output? In which case it should be:

contains([propertyReference],"demo")

The first parameter is for the variable your checking the second parameter is for the string to look for.

DataNath · Accepted Answer

Are you able to attach your workflow so we can have a more detailed look, @RMojsiak? From an initial glance, it looks like the syntax in some Contains formulae are off - normally you would express these as Contains([Field], ''). I can see you have this in some places. However, in others you use Contains('', [Field]).