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.
Solved! Go to Solution.
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.
Hi @Pascal_R
My usual workaround for this is like this
This is something I picked up from @OllieClarke long back 🙂
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.
-
Happy to help : ) @Pascal_R
Cheers and have a nice day!
User | Count |
---|---|
35 | |
27 | |
7 | |
7 | |
7 |