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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

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

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

@Shibiko 

 

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

 

Does it suit you?

 

Screen1..PNG

Cheers,

Labels