Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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





I need to combine rows into one based on few criteria, attached is sample of my data, I've played around with the summarize tool as that's I think I need to get this done but haven't had any luck. 


Row 2 in orange is my main row as that's where column B matched to column D entries, that's the column I want to keep. I'd like to somehow bring in a count of applications in column M and have it as number (green cell). The tricky part is row 3, where there will be no match of the job ID to campaign ID but I still need that row to be shown as well. I have more visual explanations in column K if this does not make sense. 


How do I approach this? 


Thank you

Alteryx Certified Partner
Alteryx Certified Partner

Hi @Shibiko 


I'm trying to understand where you're going here, but still, it's a bit confusing.

Do you want to group the 4 rows with a "Yes" into one row?




Pretty much

Alteryx Certified Partner
Alteryx Certified Partner



Not the best approach here, but the quickest I could think.


Does it suit you?