If and contains formula error
- 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 sir, may i ask you how to write multi condition "If" / "and"/ "or" formula for attached data.
Solved! Go to Solution.
- Labels:
- Expression
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@lilyyangadsk Not sure I understand your requirement properly, I think you need to your Test value equal to the (LC Alteryx Mark) value
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Is your formula same as mine? i can't see diff.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello @lilyyangadsk, your formula seems to be correct but the issue is with the Match score column whose data type was set to V-string after changing the data type to Double it is working fine.
Attaching the workflow along.
Thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
if i change to double data type, and i use my formula and second record ID still shows error. but i cant see the diff between yours and my formula :(
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @lilyyangadsk, in my version of the formula tool I did not change anything I just added a select tool and changed the data type.
In your new workflow shared there is a difference in elseif condition
Try changing to UUID Check='F' into UUID Check into ('T','F'). It will work for you as well.
Thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
may i know [UUID Check] IN('T', 'F') meaning "F"?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@lilyyangadsk, As per my understanding F might be referenced to False and T referenced to True. It is mentioned in your dataset as T or F.
Thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you!