The Summer Cup has officially kicked off! Get ready to learn, connect, and compete! Complete Community engagement tasks to earn points and unlock exclusive Summer Cup badges for your profile. Learn more 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
Top Solution Authors