Eliminate leading and trailing whitespace in the headers

[BautistaC888]

Hello,
I used the data cleansing tool on the input:

But the headers keep getting leading and trailing whitespace:

I want to know how could i fix it.
Thank you.

[PhilipMannering · Accepted solution]

Hey @BautistaC888,

You can use the Dynamic Rename Tool set to formula and use formula,

trim([_CurrentField_])

[JosephSerpis · Accepted solution]

Hi @BautistaC888 the data cleanse tool will work on the data and not on the headers. You would need to use a Dynamic Rename tool or pivot your data and then fix the headers. I've mocked up both approaches in the attached workflow.