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

Alteryx designer Discussions

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

Summarizing?

Meteoroid

Hi, 

 

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?

 

Cheers,

Meteoroid

Pretty much

Alteryx Certified Partner
Alteryx Certified Partner

@Shibiko 

 

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

 

Does it suit you?

 

Screen1..PNG

Cheers,

Labels