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.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Header contains data, need new header

rtlane
8 - Asteroid

I'm trying to complete th task of moving the header of a column (which contains data) down and adding a new header:

 

Here is my current data using the browse tool. I need the header "1  ;3;498;1.75 ;4" to become a record and then create a new header. I was able to use the dynamic rename tool to rename the header but I need to retain that data instead of just renaming it.

pic 1.PNG

 

 pic 3.PNG

2 REPLIES 2
adm510
11 - Bolide

 

In your dynamic input tool, click edit on your input template, scroll down and make sure to check the box that says first row contains data.  This will give you generic column names like Field1, Field2, etc... but more importantly it won't use your data as column names.

 

dynamicinput.png

 

rtlane
8 - Asteroid

Wow! Something so simple that I missed. lol  Thank you adm510

Labels
Top Solution Authors