I have a requirement and I have been spinning my wheels for days. I need to create a unique row(s) for all possible possibilities for each person. See below for example.
DATA FROM DB
Name | EEID | School | Office | Floor | Company |
Chase | 1 | Harvard | |||
Chase | 1 | Chicago | 23 | ||
Chase | 1 | Apple | |||
Chase | 1 | ||||
Jerry | 2 | Yale | |||
Jerry | 2 | Stanford | |||
Jerry | 2 | Dallas | 10 | ||
Jerry | 2 | New York | 18 | ||
Jerry | 2 | Alteryx | |||
Jerry | 2 | Chick Fil A |
Desired Result
Name | PID | School | Office | Floor | Company |
Chase | 1 | Harvard | Chicago | 23 | Apple |
Chase | 1 | Harvard | Chicago | 23 | |
Jerry | 2 | Yale | Dallas | 10 | Alteryx |
Jerry | 2 | Yale | Dallas | 10 | Chick Fil A |
Jerry | 2 | Yale | New York | 18 | Alteryx |
Jerry | 2 | Yale | New York | 18 | Chick Fil A |
Jerry | 2 | Stanford | Dallas | 10 | Alteryx |
Jerry | 2 | Stanford | Dallas | 10 | Chick Fil A |
Jerry | 2 | Stanford | New York | 18 | Alteryx |
Jerry | 2 | Stanford | New York | 18 | Chick Fil A |
Any guidance would be greatly appreciated.
Thank you in advanced
-Chase
Solved! Go to Solution.
Hey @Cwolfle15 ,
I got the same result as @Hadzramin_Rahman. Just using the Summarize tool instead of Unique. Great minds think alike.
Cool @NicholasM
Thank you so much!!