Updating variable and table in a loop
Greetings all!
I have this dataset:
I am looking for such outcome:
The objective is to fill up all the missing values in the “initials” column where the neighboring row in the “starting reference row” column is not a missing value too.
The details:
The “starting reference row” are already populated with values, where the starting row is the first non-missing value row. (It always starts with 14 and continues until the last row. This column will be used as reference to fulfil the abovementioned objective.)
I managed to extract the first initials using that info (in this case the first initial is 0.107 – the first initials are always given). Then all I did was fitting it onto the fixed equation inside the Math Formula Node.
The outcome of the calculation is then extracted. This is where I end up with.
I need to reuse the outcome to:
Populate the remaining rows as per the objective.
But in doing so, I will have to update the variable to be used in the equation so that each outcome will be reused to calculate the next row.
Hope this makes sense. I think maybe this is suited for the Recursive Loop Node but I don’t have enough experience in using it, so would appreciate help in solving this. Thanks!