Cross Tab is Replacing space between column names with underscores

[saiirangam]

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

[gautiergodard · Accepted solution]

@saiirangam 

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_],"_"," ")

[saiirangam]

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

[gautiergodard]

@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!

[saiirangam]

Thank you it worked