Start Free Trial

Alteryx Designer Desktop Discussions

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

Multi-field formula

Joassasj
5 - Atom

Hi expert!

 

I want to fill out the same value upper row data at below blanks fields. 

I tried to use Multi-field formula. I'm using right tool for it? 

 

Waiting for your kind guidance! 

 

Joassasj_0-1639190568431.png

 

 

Thank you, 

SJ

2 REPLIES 2
AkimasaKajitani
17 - Castor
17 - Castor

Hi @Joassasj

 

In this case you can use Multi-Row formula tool.  

You can refer the tool sample workflow.

In your case you can repeat 3 times on each field.

 

AkimasaKajitani_0-1639196223453.png

 

Result is as follows.

AkimasaKajitani_1-1639196245663.png

 

 

Qiu
21 - Polaris
21 - Polaris

@Joassasj 
I basically use the same idea as @AkimasaKajitani , but I observe that you have 3 columns to fill up, so we need to be a bit dynamic about it.

1213-Joassasj.PNG

Labels
Top Solution Authors