Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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