Permanent Headers

[sericson]

Is there a way to create permanent headers for excel files coming into Alteryx? We pull in files with several sheets/tabs and the headers are not always consistent, they sometimes have an "_" or "*" in them and we need to be able to bypass the input files headers and have our own that are the same each time. Any help would be appreciated!

[MilindG]

@sericson See if this works for you

[Felipe_Ribeir0 · Accepted solution]

Hi @sericson 

If i understood your problem correctly, here are two options.

Option A: Use the dynamic rename tool to replace special characters.

Option B: Use the find replace tool to get the cleanned headers and the dynamic rename to replace it.

[ArnaldoSandoval]

@sericson 

I added a "field mapping" level to the workflow.