How to Reset Row ID after Merging Several Excel Files?

dixonchan · June 15, 2020, 3:47am

After using Concatenate node to merge multiple excel files, the Row ID is messed up. (See screenshot)
Capture

How do I reset the Row ID, so that it runs incrementally? Eg. Row408, Row409, Row410

Thanks.

morpheus · June 15, 2020, 4:04am

Hi @dixonchan,

you can use the RowID-Node for that.

https://nodepit.com/node/org.knime.base.node.preproc.rowkey2.RowKeyNodeFactory2

BR

dataminer_1 · June 17, 2020, 11:04pm

Yes, the RowID node will do it. Just leave it unconfigured. It will complain to you about that; just ignore it, and execute it. The node will build a new RowID for you by default.

dixonchan · June 18, 2020, 8:12am

Awesome! Thanks for your help.

system · December 17, 2020, 8:21pm

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