Alteryx Designer Discussions

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

How to fill down and/or fill up in multiple columns?

HW1
8 - Asteroid

I have 2 rows of column headers coming from an excel file 

 

A few of these rows are null. I want the null in the first rows to be filled from below and the ones with nulls in the second rows to be filled from above.

 

I am trying transpose and then fill down but its not working perfectly.

 

I tried the multi row tool with the formula

 

IF [Name] = [Row+1:Name] // Checks if the row values match with the below

AND ISNULL([Row-1:Value]) // Checks if the row has nulls
THEN [Value] // Then fill down
ELSE NULL()
ENDIF

 

 

How can I do it?

 

Please find attached workflow example.

3 REPLIES 3
HW1
8 - Asteroid

I tried this however, this one goes one way only (Fill Down).

There might be better ways to do it.

 

(If there are better solutions, I'll accept them as an answer else, this can do)

Qiu
17 - Castor

@HW1 
I think you are almost getting there.
Just modified a bit about the Sorting.

1125-HW1.PNG

Ben_H
11 - Bolide

Hi @HW1,

 

I'm not quite sure I follow what you're aiming for but I've had a go based on your example.

 

Ben_H_0-1637859485749.png

Regards,

 

Ben

 

Labels