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.
Hi @Pascal_R
Sorry my bad slight formula change.
Hope this helps : )
@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
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.
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.
My usual workaround for this is like this
This is something I picked up from @OllieClarke long back 🙂
@atcodedog05 With your solution I still get the issue for below:
