if contains elseif troubleshoot
- 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
hello,
I'm having a slight issue with my expression. can someone please help.
so basically I input the formula tool. And what I planned to have was ' change of bo', 'change of ppo', 'constitutional doc - ownership proof' and 'constitutional doc - ownership proof (cosima)' to have the field [Team2] to be autofilled a text "to check" and the rest as "not asc". however when I ran the workflow, all of the rows in [Team2] were filled as 'not asc'.
alteryx couldn't pick up any error within the expression, so I'm just curious as to what went wrong.
Regards,
Lance
Solved! Go to Solution.
- Labels:
- Tips and Tricks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@lancegoh1I would try switching the order of your last two conditions.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
hi Patrick, I tried to put only 1 condition but expression is still filling the entire field with 'not asc' as shown below.
Regards,
lance
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi
Can u able to share the input!
Regards
Surendar.C
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
There's nothing obviously wrong with what you've posted, but what does the Input data look like ? Does it match the exact CaSe That You have SpeCiFied ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Edit: I'd like to change my answer to direct you to the comment below by @harikakummara That's better than what I originally had.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Lance,
It may be due to "Space" or "text match" issue. For text match issue, try using "Uppercase" function on column "[Doc Code (pre-1P)]" . For "Space" issue, try removing extra white spaces or copy exact text from [Team 2] column.
Either ways, it would be better if you can provide a sample of data here.
Thanks,
Harika Kummara
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Single vs. double quotes?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@kklein12 Single vs double doesn't matter as long as you stay consistent in the formula with one exception:
If you're quoting a string which contains a single or double quote, then you must use the opposite to enclose it.
For example if you're searching a text field for the string: It's a string
You would use:
Contains([FieldName],"It's a string")
If you were searching for the string: A "string" in the text
You would use:
Contains([FieldName],'A "string" in the text')
