Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Permanent Headers

sericson
8 - Asteroid
‎08-04-2023 11:06 AM

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!

Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

3 REPLIES 3
MilindG
12 - Quasar
‎08-04-2023 11:16 AM

@sericson See if this works for you

Column Name.yxmd
Reply
0 Likes
Felipe_Ribeir0
16 - Nebula
‎08-04-2023 11:22 AM

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.

 

Rename.png

Headers.yxmd
Reply
0 Likes
ArnaldoSandoval
12 - Quasar
‎08-04-2023 11:30 AM

@sericson 

 

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

Column Name-v01.yxmd
Reply
0 Likes
GenAI Contest Form
License admin COmmunity Live
Labels
Top Solution Authors
View All