Start Free Trial

Alteryx Designer Desktop Discussions

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

Combine rows removing null values

Dheeru28
8 - Asteroid

Hi there,

I have the following input:

 

Items          Monday    Tuesday   Wednesday

Dinner             8                Null            Null
Lunch              3                Null            Null
Dinner          Null               23              Null
Lunch          Null                15              Null
Dinner         Null               Null              17
Lunch          Null              Null                7

I need the output in the following form:

Items            Monday    Tuesday   Wednesday

Dinner                8               23                17

Lunch                3               15                  7

 

How to go about getting this output?

 

Would really appreciate your help. Thanks in advance!

3 REPLIES 3
ShankerV
17 - Castor

@Dheeru28 

 

One way of doing this.

 

ShankerV_0-1684497114847.png

 

ShankerV
17 - Castor

Hi @Dheeru28 

 

Step 1: Input

 

ShankerV_0-1684497159437.png

 

 

Step 2: 

 

ShankerV_1-1684497176226.png

ShankerV_2-1684497184080.png

 

Many thanks

Shanker V

Dheeru28
8 - Asteroid

Thanks a lot @ShankerV 

It's really helpful.

Labels
Top Solution Authors