Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Output Data Without Header into Excel Template

kheuer
8 - Asteroid

Hi - 

 

I am using a formatted Excel template with specific named ranges. When I output data from an Access table into the Excel named range, the header from the Access table is pasted into the Excel named range. Is there a solution to skip the header record when pasting into the Excel named range?

 

Thanks much,

Kristina

5 REPLIES 5
Claje
14 - Magnetar

There is probably a better solution than this, but I tried a couple things and didn't make a ton of headway.


There is a tool called "Dynamic Rename" which has an option for the rename mode "Take Field Names from First Row of Data".


If you set that up right before your output tool, I believe that it will accomplish what you are looking for, even if it is a bit of a workaround.

kheuer
8 - Asteroid

Thanks, @Claje. It solved my problem, except that I can now no longer output data into separate tabs based on a specific field.

 

If there are any other solutions, I'd like to see if there is a different option.

 

Thanks for the quick reply though!

Claje
14 - Magnetar

If that field is a part of your final output, you can use a formula tool before the dynamic rename to create a duplicate of this field, and deselect the duplicated field in the dynamic rename tool.  Then you can use the new duplicate field in the Output Data options to change the sheet name, and uncheck the "Include in file" box.

Again, there might be better options so I don't want to say this is the be-all end-all, but this should work for your need.

kheuer
8 - Asteroid

Great idea, that worked!!! Thank you so much.

marlline
8 - Asteroid

@Claje

In my output, the first row of data is already text. Please help.

 

Text Alteryx.JPG

Labels