Column Add and Sort by Rule

I am doing a data study on the Knime application. I have loaded a data table into the application. 145 damage files have been repeated three times. I want to write 1-2-3 for each damage file in a new table and bring it next to the 145 damage files.**

For example:

Column 1 Column 2
X 1
X 2
X 3

Its not clear what you’re trying to do. What do you mean by “145 damage files have been repeated three times”? Could you upload your input data and explain in more detail the output you want?


hi, here it is,

ı want to write each of file 1-2-3

Aylık tediye inceleme çalışması.knwf (132.1 KB)

@roberto_cadili ı mentioned it last night

Ah ok, @mecitsaglam , we can’t run your workflow because we haven’t got the xlsx file but from your screenshot I see that the “Hasar Dos…” column has the number repeated three times, so I think what you are saying is that against these you want 1,2,3,1,2,3… to be written repeatedly in a new column for each row.

With your table sorted as it is, you can do that with Math Formula node using the “modulo” operator (%) in the following formula:

$$ROWINDEX$$ % 3 + 1


Thank you so much, it’s working

1 Like

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