I have table like this:
row0 1, 10, 100
row1 T1, T2, T3, timestamp
row2 123, 321, 221, 2023-08-21T13:49:45
Row0 are divisors. Row1 is header row.
This is the expected row outcome:
row2 123, 32.1, 2.21
I have been able to separate divisors and the rest of the table with table splitter. Then I have tried to inject divisors and the rest of the table to Math formula (multi column).
Divisors as table row To variable and table row to variable loop to math formula’s variable Inport.
I haven’t been able to divide columns with divisors. As I understand $$CURRENT_COLUMN$$ holds selected columns and all selected columns are processed.
How can I do something like this: $$CURRENT_COLUMN$$/divisor column?
So current column values get divided with correct divisor.
And there is another problem. There is missing rows i.e. timestamps are not spaced evenly. I have seen few tutorials, but nodes that are used in those are no longer available.
Really appreciate any help.