Alteryx Designer Desktop Discussions

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

Fill up values: Multi Row formula tool does not work?

HW1
9 - Comet

I am trying to fill up the Site Name column however the formula is not working as it is supposed to.

 

Formula:

 

IF ISNULL([Site Name])
THEN [Row-1:Site Name]
ELSE [Site Name]
ENDIF

 

What am I doing wrong?

 

Please find example workflow attached.

 

Thanks

3 REPLIES 3
Qiu
21 - Polaris
21 - Polaris

@HW1 

I think we need to do a sorting first, to bring the non-null value for site name to top, then the multirow formula will work.

Capture2.PNG

HW1
9 - Comet

Yep, that works however why would the fill up formula not work?

 

What you have provided is a fill down solution and I have a use case for a fill up.

 

Thanks

atcodedog05
22 - Nova
22 - Nova

Hi @HW1 

 

Fill up wont work because the execution is always top to down. Hence you need to add a record id tool reverse the order so that you can perform Fill down.

 

Hope this helps ðŸ™‚

Labels
Top Solution Authors