Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
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