Start Free Trial

Alteryx Designer Desktop Discussions

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

Multi row formula

Sarath27
8 - Asteroid

Hi All,

 

Just like in Excel, if a row value is picked up from particular row, i.e A2=A4

 

I want Row # 2 value should be populated in Row #4

4 REPLIES 4
Luke_C
17 - Castor
17 - Castor

The multi-row tool can reference other rows in your data. To get the best answer can you expand on the logic? Is your data always going to be in row 2 and need to be copied in row 4? In your screenshot the values in each cell don't match to what your formula examples say.

Sarath27
8 - Asteroid

The formula here is 

 

Row # 2 - Client - 340110255 should be populated to Row # 4 - Client Cash Utilization. 

 

In short, Sum-2023-06-27 Values should be same for both Row # 2 & Row # 4- Please suggest the best. Thanks.

Luke_C
17 - Castor
17 - Castor

Hi @Sarath27 

 

Here's an example. Hopefully this is helpful - based on the limited data available I'd imagine this will need to be modified for your actual workflow. 

 

image.png

grazitti_sapna
17 - Castor

Hey Sarath27

I have attached the workflow for your ref.

Sapna Gupta
Labels
Top Solution Authors