We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Combining rows

Sifiso
8 - Asteroid

Dear all

 

I would like to combine rows if the sub categories are the same

 

Category

Subcategory

Amount (Cuba)

Amount (Mozambique)

A

A1

4

Null

A

A1

Null

3

A

A2

Null

5

A

A2

6

Null

 

Required Output

Category

Subcategory

Amount (Cuba)

Amount (Mozambique)

A

A1

4

3

A

A2

6

5

2 REPLIES 2
Luke_C
17 - Castor
17 - Castor

Hi @Sifiso 

 

You can use the summarize tool:

 

 

Luke_C_0-1658756780687.png

 

messi007
15 - Aurora
15 - Aurora

@Sifiso,

 

You can do this with Summarize and longest option :

 

 

messi007_0-1658756858678.png

 

Attached the workflow,

Regards,

Labels
Top Solution Authors