Need help creating logic to identify multiple values linked to another 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
Hoss2434
7 - Meteor
‎03-16-2023
01:33 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello I am trying to create logic that will check if a value from column has a one to many relationship to a value in another column. Here is a before and after example of what I am looking for:
Before:
Customer# | Color |
1 | red |
1 | red |
2 | blue |
2 | red |
3 | blue |
3 | blue |
After:
Customer# | Color | Both Colors? |
1 | red | No |
1 | red | No |
2 | blue | Yes |
2 | red | Yes |
3 | blue | No |
3 | blue | No |
So in this example we can see that Customer #2 has a record of both "blue" and "red" for it's colors, and there fore the third column marked it "Yes"
If anyone can show me how to create a formula for this that would be greatly appreciated!
Thanks!
Labels:
- Labels:
- Reporting
3 REPLIES 3
SPetrie
13 - Pulsar
‎03-16-2023
01:49 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I think a summarize with count distinct should give you the info you want. Join the result back to the original data set to have it apply to each instance.
binuacs
21 - Polaris
‎03-16-2023
01:53 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
gaoa
11 - Bolide
‎03-16-2023
10:28 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
![](/skins/images/9780FA8738778E76CAA545EFAA4CDA4D/responsive_peak/images/icon_anonymous_message.png)