SOLVED
Evaluating if columns contains "Yes" then tag that row as "Yes" in a new column
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Masond3
8 - Asteroid
‎02-22-2024
04:23 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey Team,
Daft question I have 3 columns, i want check across those 3 columns if any of those columns has "Yes" then in a new column called "Outcome" then populate with value of "issue".
Input
Name Match | City Match | Country Match |
Yes | No | Yes |
No | No | No |
- | - | - |
Expected outcome
Name Match | City Match | Country Match | Outcome |
Yes | No | Yes | Issue |
No | No | No | Not Applicable |
- | - | - | Not Applicable |
Looking forward to your response
Regards
Masond3
Solved! Go to Solution.
Labels:
- Labels:
- Common Use Cases
2 REPLIES 2
16 - Nebula
‎02-22-2024
04:34 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
hi @Masond3
You can use Formula tool, and create new field "Outcome" with the below expression.
IF "Yes" in ([Name Match], [City Match], [Country Match])
THEN "Issue"
ELSE "Not Applicable"
END IF
HomesickSurfer
12 - Quasar
‎02-22-2024
07:47 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
