Dear all,
I’d like to suggest to extend the RowID node to allow extraction of the row index.
Reasoning
The RowID as a string when sorted leads to a wrong order. It sorts all starting with 1 – regardless if it’s 1, 100 or 1000 – prior to 2. This becomes an unnecessary struggle when i.e. a Column Appender is used. Extraction and usage of the row index is natively supported by almost every other node, though. But not the RowID node.
Kind regards
Mike