Hello Alteryx Community,
Just started using designer and would greatly appreciate any help with this task that I have spent hours with no respite!
I am looking to feed the Part # and Plant ID as inputs in a spreadsheet and get the below two columns as output in the same spreadhseet:
1. Unique Part #
2. Count of unique Plant IDs corresponding to the unique part #
The below table provides a reference for what I am looking to do with 50,000+ part numbers.
| Part # | Plant ID | | Part # | count |
| 21 | 2 | | 21 | 3 |
| 21 | 8 | | 20 | 2 |
| 21 | 6 | | | |
| 21 | 8 | | | |
| 20 | 124 | | | |
| 20 | 11 | | | |
| 20 | | | | |
| 20 | 11 | | | |
Thank you in advance for the help!
