"Contains" function not working
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
- Labels:
- Data Investigation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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], '<Target>'). I can see you have this in some places. However, in others you use Contains('<Target>', [Field]).
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
😤 I thought it was something really simple as that. It seems that I need to go back to the training lessons, even though I did that formula hundreds of times. Sorry for the post...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
No worries @RMojsiak, happens to us all. Please do post the filter one if you can replicate it. Doubles can behave strangely.
