Alteryx Designer Desktop Discussions

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

Need to generate rows based on a condition

Sameer_Kanade8810
7 - Meteor

Hi All,
I have a data set below as a sample.

DATE  Value              Begin Value   End Value

 1/1          0.0008             211.200        (1+[Value]*[Begin Value]   

 1/2          0.0008                ?                 (1+[Value]*[Begin Value]

 

My 1/2 Begin value should nothing but the End value of 1/1

 

How do i get the begin value .
Also note begin value will be derived from another source but it should only be updated to the first row of begin value.
Any help on this will be highly appreciated.

4 REPLIES 4
geraldo
13 - Pulsar

@Sameer_Kanade8810 

 


I'm sorry, but with these data that you put, I did not understand your objective.

if you could explain in two more lines it would make my understanding easi

lynnesonneyrsm
8 - Asteroid

Hi @Sameer_Kanade8810 !

 

This looks to me like an interest calculation. The simplest way I could come up with is attached. I generate rows for the dates first, then calculated the beginning balance based on the previous row. From there I can calculated the "END" balance straight across. 

 

Let me know if this helps!

nagakavyasri
12 - Quasar

Use Muti-Row formula tool

Screenshot 2023-06-01 155135.png

Sameer_Kanade8810
7 - Meteor

Thank you all for the help.

Labels