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!