Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.

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