Cross Tab is Replacing space between column names with underscores

I am having around 150 rows that needs to be converted into Column Names, whenever I use Crosstab tool it auto replaces space between the column Names with Underscores is there any way to avoid this, My Column Names are dynamic and keep changing every time.

Is there any alternative way to do this rather than using Select tool to renames these column names just to remove Underscore in the headers

Developer

Accepted answers

Yes ! You can use the dynamic rename tool in the developer tool pallet.

Select all of the columns (including dynamic or Unknown Fields) and select Rename mode: Formula

Then use the formula below:

replace([_CurrentField_],"_"," ")

All comments

Yes ! You can use the dynamic rename tool in the developer tool pallet.

Select all of the columns (including dynamic or Unknown Fields) and select Rename mode: Formula

Then use the formula below:

replace([_CurrentField_],"_"," ")

@gautiergodard Thank you heads up , does this apply for Headers are data?

@saiirangam Correct, this will apply to the column headers in your data set.

Please dont forget to accept this post as a solution if it answered your question!

Thank you it worked

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703