ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

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

Combine Rows in to one based on a criteria

Ravi
7 - Meteor

Hello! Can someone please let me know how to combine the rows using Alteryx Tools. Thanks!

Alteryx Data.PNG

6 REPLIES 6
AngelosPachis
16 - Nebula

Hi @Ravi 

 

Here's one way you can do it:

 

AngelosPachis_0-1635460332575.png

 

Qiu
21 - Polaris
21 - Polaris

@Ravi 
Tried something different. 😁

1029-Ravi.PNG

sparksun
11 - Bolide

Just two tools can make it happen.

 

sparksun_0-1635474774307.png

 

Ravi
7 - Meteor

@AngelosPachis Sorry for replying late, it worked. Thank you!!

Ravi
7 - Meteor

@Qiu @AngelosPachis Thank you both! your solution worked as well. Many thanks!

Qiu
21 - Polaris
21 - Polaris

@Ravi 

Glad to help and thank you for the accept mark.

Labels
Top Solution Authors