Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
Hi! I need help with a small (I am assuming it will be small) workflow that takes HDMI number and HDMI name and all the data beneath it and turns it vertically. I tried using some tools in Alteryx, but where I am struggling is Alteryx only takes one row as the headers. So it was taking HDMI Number only. HDMI name was just another random cell in the data and it wasn't transforming properly.
Specific things I want: Cord Account and Cord description are already perfect. Those need to stay vertical. HDMI number and HDMI name are currently horizontal and need to each be their own columns (vertical). The numerical values need to all be in one column together (We can call it End Values), not running horizontally. Last thing, I do not want the TOTAL row nor the Combined column in my final data. That can be excluded. Only columns with HDMI numbers should be accounted for.
Any help on this would be deeply appreciated, thank you so much Alteryx community :)
@slaurel I used the Transpose tool to flip everything on its side then the Dynamic Rename tool to rename both columns with the first row of data, which was HDMI Number and HDMI Name.
