Hello,
My initial data looks like this. The Pole_ID's are showing as duplicates because some Pole_ID's have multiple Circuit1:
| POLE_ID | CIRCUIT1 | SYSTEM_VOLTAGE |
| 27399706 | B-109-J | 4.16 |
| 27399706 | B-14-J | 4.16 |
| 27399707 | B-109-J | 4.16 |
| 27399707 | B-14-J | 4.16 |
| 27399708 | B-109-J | 4.16 |
| 27399708 | B-14-J | 4.16 |
| 27399710 | B-109-J | 4.16 |
| 27399710 | B-15-J | 4.16 |
| 27399715 | B-14-J | 4.16 |
| 27399716 | B-109-J | 4.16 |
| 27399716 | B-14-J | 4.16 |
| 27399716 | B-15-J | 4.16 |
The output that I would like to get is that if a Pole_ID has multiple Circuit1, then each different Circuit1 be outputted into a new column along with its associated System_Voltage.
Output example:
| POLE_ID | CIRCUIT1 | CIRCUIT2 | CIRCUIT3 | SYSTEM_VOLTAGE |
| 27399706 | B-109-J | B-14-J | | 4.16 |
| 27399707 | B-109-J | B-14-J | | 4.16 |
| 27399708 | B-109-J | B-14-J | | 4.16 |
| 27399716 | B-109-J | B-14-J | B-15-J | 4.16 |
Can anyone help with showing me a sample workflow in Alteryx on how this could be done?
Thank You.
