Please see attached Alteryx workflow output thus far. What I am trying to do is assemble a list of necessary projects to track - that would be the combined column header + deliverable type for any line where the total hours exceeds 0.
Example output for the column with the header Project_1:
Project_1_Deliverable Type_1
Project_1_Deliverable Type_3
Project_1_Deliverable Type_6
I have multiple projects in columns with hours by deliverable type across in rows. I'd like the end result to be a single list that shows the concatenated Project & Deliverable Name combined for any project with hours >0.
I was originally going down the path of individual formulas for each column, but there has to be a better way.
Thanks in advance!
Solved! Go to Solution.
Hey @JGalle0121
Transpose tool is your friend here :)
Part time Tableau, Part Time Alteryx. Full Time Awesome
Thank you both! I confess I'm so used to my data being in columns that I hardly use Transpose - now I'm thinking, duh. Sometimes you just need another pair of eyes. Gave you both stars, have a great day!