Hello!
I am trying to condense a data set into one column. The problem is the number of columns will vary from week to week, sometimes I will have more than the 4 filled in columns in the screenshot, which is the reason the concatenate formula goes out to "bk". I was using the formula tool to simply add each column together however I want to automate this workflow and I wont be able to do that if I continue using the formula method. Does anyone know of a way to something similar to the below in alteryx?
¡Resuelto! Ir a solución.
Greetings!
I would give each record a Unique ID with the RecordID tool, then use the Transpose Tool with the RecordID chosen as the Grouping Field. From here I would use a Summarize, and Groupby recordID, and concatenate the other column. Let me know if this helps, I can throw together a quick example if you need it :)
This is perfect thank you so much!
Hello Kindly @Paulteryx I could use that quick example if you don't mind?