Hello Alteryx Community,
I have a problem that has left me stumped and I am hoping someone here has the insight to overcome it. My data in its simplest form resembles the following:
| Data |
| Project ID | Group ID | Name |
| Project A | 123 | Bob |
| Project B | 234 | Jane |
| Project C | 345 | Peter |
| Project D | 456 | Barb |
| Project E | 567 | Luke |
| Project F | 678 | Dave |
| Project G | 789 | Sarah |
| Project H | 890 | Julie |
I have a data file that has multiple Group IDs and the name of a user currently assigned to that group. I need to return many combinations of names depending on their group number to show a hierarchy. However, while the Group ID's will remain static from a logic perspective, the names will change. Therefore, I need to have an output that looks like Bob, Jane, Peter but is tied to Group ID 123, 234, 345 so that if Jane is replaced with Alex tomorrow, the output would then automatically change to look like Bob, Alex, Peter with Alex being the name associated with Group 234. I will have close to a hundred of these combinations but the output would need to look something similar to:
| Output | Logic |
| New Column | New Column |
| Jane, Barb, Sarah | Option 1 - Name of Group ID 234, Name of Group ID 456, Name of Group ID 789 |
| Luke, Bob | Option 2 - Name of Group ID 567, Name of Group ID 123 |
| Luke, Dave, Jane, Julie | Option 3 - Name of Group ID 567, Name of Group ID 678, Name of Group ID 234, Name of Group ID 890 |
| Dave, Peter, Barb | Option 4 - Name of Group ID 678, Name of Group ID 345, Name of Group ID 456 |
| | etc. |
Where the Output column is what the data output would look like but it is driven by the Logic so that if Names change they will maintain the display based on the new names associated with the Group ID's. Based on my research this likely involves Join tools but I cannot figure out the right combination to generate the desired outcome.
Any help would be greatly appreciated.
Tyler
