community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Return Ticket by Team that includes blanks

Meteor

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!

Asteroid

See attachedCapture.PNG

Alteryx Certified Partner

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.

 

clipboard_image_0.png

M.

Meteor

I am sure this works perfectly but my version of alteryx would not open it. Thank you for your support.

Labels