Cross Tab tool adds _ in new header

[Pascal_R]

Hi Community,

I try with attached dataset to change column headers with the Corss Tab tool.

Do you know why the header names are changing (adding "_" )?

I need to have the exact naming.

[JosephSerpis]

Hi @Pascal_R a number of tool don't like a space in the header such as some of the Transforms tool. Typically in this usecase you would use a dynamic rename tool to achieve the desired results. I mocked up an approach that demontrates that.

[atcodedog05]

Hi @Pascal_R 

My usual workaround for this is like this

This is something I picked up from @OllieClarke long back 🙂

Hope this helps : )

[Pascal_R]

@atcodedog05  With your solution I still get the issue for below:

[atcodedog05 · Accepted solution]

Hi @Pascal_R 

Sorry my bad slight formula change.

Hope this helps : )

[OllieClarke · Accepted solution]

@atcodedog05 the cross-tab tool will replace any instance of a non-alphanumeric/underscore with a single underscore, so actually you want your formula to be:

Regex_replace([field],'\W','_')

(i.e. remove the '+')

Hope that helps

[JosephSerpis · Accepted solution]

Hi @Pascal_R this why the Field Info tool is useful it has the orginal Name in the Source field which you can then extract and use in the Dynamic Rename tool.

[atcodedog05]

Hi @OllieClarke 

Yes got it. Had added it there by mistake rectified it 😅

[atcodedog05]

-

[atcodedog05]

Happy to help : ) @Pascal_R 

Cheers and have a nice day!