This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
My initial data looks like this. The Pole_ID's are showing as duplicates because some Pole_ID's have multiple Circuit1:
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.
Can anyone help with showing me a sample workflow in Alteryx on how this could be done?
Go to Solution.
Go to Solution.
See workflow appended.
EDIT: I put the circuit name in each column, correcting the Cross-Tab Tool.
- Tile Tool to group the ID in sequences.
- Formula Tool to create Circuit + sequeence number column
- Cross-Tab Tool to put in order.
Thank you for you quick reply, however I don't see the option to Concatenate under Method for Aggregating Values with the Cross Tab Tool. How can I get this Concatenate option to come up?
Change "Values for New Columns" option to "CIRCUIT1", which is the field with your circuit names.
Works perfectly! Thanks a lot for the help.
Sometimes there are cases where the same circuit will also have different voltages:
Is it possible to have an output that can have separate columns: Circuit1, System_Voltage1, Circuit 2, System Voltage 2 etc. for the same Pole_ID:
Yes it is.
Create SYSTEM_VOLTAGE sequence as you did with CIRCUIT in formula tool.
Then, you split your Cross-Tab step in two. One for the Circuits, and the other for System Voltage.
Join by Pole_ID and bring the fields together. You might leave the "Unknown" box of the Join Tool checked as new fields can show up depending on how many circuits and voltages per Pole_ID.