How to Reset Row ID after Merging Several Excel Files?

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

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


Hi @dixonchan,

you can use the RowID-Node for that.



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.

Awesome! Thanks for your help. :grinning:

1 Like

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