Need to order the table with a counter

Hello all,

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

Hi and welcom Mohamad,

you Need to create a table in Excel with one column from 0 to 1800.
and right(or left) join this table with your 3 columns table via the first column.

Be sure that the one column table is the right table else use left join.
BR

1 Like

Hey,
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 ?

As I told you, you need to be sure that the created one column table is the right table to use the right join.
Then you need to replace missing values with 0 using missing values node

Hi again,
Can you send me a screenshot of what is needed ?


Tab1 contains the data and Tab 2 the counter.

This is what I mean.
I hope it helps!
Med100.knwf (16.7 KB)

2 Likes

It works, thank you very much

2 Likes

Hi there!

Just to add that there is Counter Generation node that can be used instead of Loop. A bit faster :wink:

Br,
Ivan

2 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.