I am in trouble here, I have a table that has 3 columns, the first has some values from 0 to 1800 (i.e. 500, 451, 1123, 321, not all the values from 0 to 1800 are present i.e. I have less rows than 1801), and the other two columns have data connected to the specific values in the first column i.e. I want them to stay attached to them.
I want the first column to be ordered from 0 to 1800, but not to lose the row data connected.
Suppose I have
112 85 3
200 12 1
I want the first to become
0 0 0
1 0 0
2 0 0 …
112 85 3
1800 0 0
If there is a simple way to do so, would appreciate it.
Thank you for your response, but it doesn’t work.
I built the table then used the joiner node.
It keeps only the values that are already present and then places the created below.
I wanted it to combine the two then place zeros wherever there is a missing value.
Is there another method ?