I have ticket data in which i need all of the teams except the green team. Each ticket is listed multiple times because when the status changes it creates a new row of data. I need to return the data from every team except the green team. For example if I use the filter to only give me tickets from the red team I will lose many records as some of their names are blank when the rows get added. I also cannot just populate the rows with the team name because teams can change. Shown in the data on ticket number 3 it starts with the yellow team and ends with red team.
In the document I have the data and what the ideal outcome is in the next tab. Thank you!
Solved! Go to Solution.
Hi @Fred22 ,
Solution attached.
I simply generated the team names using the multi-row formula, then filtered out the green team and dropped the extra column.
M.
I am sure this works perfectly but my version of alteryx would not open it. Thank you for your support.