Insert Serial Number Column

[Charm_Myae]

Dear All,
Good day to All.

May I request a way to insert the serial number column in my data.
Which node and how can I use it?

Thanks All.

[rolandnemeth]

Hi @Charm_Myae,

what do you mean under serial number column exactly?

Roland

[Thyme]

Hi,

I’ll take a guess and suggest the Constant Value Column Node? It appends a column with a fixed value or allows to use a flow variable to change the value dynamically.

Let us know if you need something else.

Constant Value Column

Happy New Year, T

[Charm_Myae]

Thank you very much @Thyme.

[Charm_Myae]

Hi @rolandnemeth,
I mean that, in my data table, originally did not include serial number column, I want to add Serial No. Column 1, 2, 3, …

Not only one file, but they are also monthly continuous data files. I also consider preparing in Excel before importing to KNIME, but it is not OK.

Like Power Query => Add Column => Index Column (from 1).

Thanks.

I got some ideas from @Thyme.

[rolandnemeth]

hi @Charm_Myae,

If you would like to implement the row counter with sorting, I suggest the Rank node.

If you would like to simply add the row count for each row, I propose the Counter generation node. This is the same as the Power Query function, what you mentioned, you can set up the start value and the scaling in the node settings.

Please have a look at the attached workflow.

Best Regards,
Roland

Row_Counter.knar.knwf (8.0 KB)

[Charm_Myae]

Hi @rolandnemeth,

Thank you very much for your suggestion.
I got the solution with your suggestion “Counter Generation Node”.

[rolandnemeth]

@Charm_Myae you are welcome!

[omprakashjena]

Hi @Charm_Myae ,

Please see the workflow in KNIME Hub. More simple and straight forward.

Insert Serial Number – omprakashjena

Thanks!