Compare list of values
- 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
I'm looking to compare a list of values by there prefixes. So the data is simple, it looks like:
id | order_no
A | B6DKG
A | B6DKG
B | C2D63
B | C4D92
So I want to, for each id, check the order numbers by their two-digit prefix (B6, C2, C4). If the prefixes match under one id, then do nothing. If they are different, assign a field that says "multiple" for those records. Thank you.
Solved! Go to Solution.
- Labels:
- Input
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Here's one approach using the summarize tool to count the distinct prefixes and flag the IDs with multiple:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @The_Alternator ,
Assuming that your input looks something like this
you can using the following workflow to create that flag of multiples by counting the different prefixes appearing with a summarize tool
Hope that helps,
Angelos
