How to remove underscore from all the columns

[gagandeep_dhall]

Hi Everyone,

I have a file which will have a column added to it everytime a file comes for a month.

But, when I use Cross-tab to group them and create that column, it adds "_" to the column Name, as below:

Process Name	Dec_2020	Jan_2021
Process 1	abc	bcd
Process 2	gbd	gsh

I know I can use "Dynamic Rename" tool, but it doesnot works on the new column that gets added every month.

[DavidP]

I would use a technique like this to replace the underscores after the Crosstab.

[pedrodrfaria]

Hi @gagandeep_dhall 

Just for context and educational purposes. The dynamic rename should work with new columns. If you check the Dynamic or Unknown Fields option, it will update new incoming fields that did not exist on the previous month.

@DavidP 's solution also is a good way to get around it.

Pedro.

[MikeLR]

This is now available as standard in release 2024.2 🙂 With the AMP engine enabled you see this checkbox: