Free Trial

Alteryx Designer Desktop Discussions

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

Add a row with a formula?

yuvalshmul
6 - Meteoroid

Hello,

 

In the flow attached, the first table has the input and the second has the (ideal) output

 

Basically, I need to add a row to the data that would substract the fourth row from the first row across all columns

 

Row 5 = Row 1 - Row 4

 

How could I do so?

 

Thank you so much!

Yuval

3 REPLIES 3
Emil_Kos
17 - Castor
17 - Castor

Hi @yuvalshmul,


I believe that your output file was incorrect. I have used the data in the input to create the expected output for you:

 

Emil_Kos_0-1624483025756.png

 

Qiu
21 - Polaris
21 - Polaris

@yuvalshmul 
This is my try.

I am wondering if it can be easy as in Excel 😁

Capture1A.PNG

Emil_Kos
17 - Castor
17 - Castor

Hi @yuvalshmul,

 

Did you get the answer that was helpful?

Labels
Top Solution Authors