Global replace on column names

Support and Helpdesk
2

So this is the workaround I am currently using:

  1. Make sure you have an id column at the beginning (if not just create one using row.index).
  2. Use Transpose to create a key and a value column from the other columns.
  3. Transform the key column (e.g. using replace or other mass operations.
  4. Fill down the id column.
  5. Transpose the key and value columns back to the column based format.

If you have some deeper nesting in your XML data, make sure you keep the empty cells to be able to reconstruct the original layout. There is an option for that in the Transpose dialog.

1 Like