Update if value is present
- 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
Having a hard time getting this to work...
I would like to create a column that will flag "yes" or "no" if a certain status is present in [Tolerance Status] column, but I need it to look per [Tank Name] (I have multiple different Tank Names in my data, just using the one as example). Regardless of the "Complete" Status, so on all three rows, I would expect "yes" since "Pending Haul" is present. In this particular example, the Tank Name is the same in all 3 rows. I have over 800 distinct tank names w/ multiple rows so I will need to give me the "yes" result if in any rows there is 'Pending Haul' regardless if there are other rows w/ 'Complete'.
- Labels:
- General
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @young351 so are you saying even if the status is Pending Haul it should still be Yes?
- 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
Yes. I am wanting to flag if there is an open ticket, Pending Haul. So even though I am seeing 2 rows (2 tickets) that are Complete, I need my end user to see that there is an open ticket already created (Pending Haul). Hope that makes sense.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@young351
You could use a Formula tool to create a new column (maybe call it Pending) as a Boolean depending on whether Tolerance Status contains 'Pending'
Contains([Tolerance Status}, 'Pending')
and then use a Summarize tool to group by Tank Name and provide Max value for Pending. Booleans are 0=false and 1=true, so max value for the group shown above would be 1, and therefore be true.
Principal Support Engineer -- Knowledge Management Coach
Alteryx, Inc.

