Column Renamer (Dictionary) confusion: 'ID', 'Row ID', or 'RowIDs'?

I need to convert all my csv column names to uppercase. I was hoping the Column Rename (Regex) could do this with a simple U function but I couldn’t get it to work. So instead I found a relatively simple solution, after a bit of digging:

replacecols

First of all, can this be done in one tool? Or is my workflow the right way?

Second, please can someone explain the following inconsistency in column names as I’d like to understand better for future:

  1. The node monitor for my string manipulation shows ‘ID’ to the left of my actual column, highlighted in yellow below
    1 ID

  2. But if I right click and open the table in a separate window, it’s now ‘Row ID’
    2 Row ID

  3. And in the Column Renamer (Dictionary) config it’s now mysteriously ‘Row IDs’
    3 RowIDs

Three different references for the same thing! Seems a bit confusing. What’s going on here? Thanks

Hey @J_Knime_Work ,

your workflow is a nice solution to the task. I would do it the same way.
The different naming indeed is a problem that sneaked in over time (and you may even find more references like “row key”). One of our goals with the modern UI is to harmonize these inconsistencies. “RowID” is the name we use now.

Best regards,
nan

2 Likes

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