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

Write an Excel output Without a Headerline

kelkboom
7 - Meteor

Hello, 

 

Is it possible to write an Excel file without inserting the Headerline (Column names) in the output file..

 

Regards Humberto 

4 REPLIES 4
pcatterson
11 - Bolide

I don't know a way to do this with the typical output tool, but you could use a browse and copy out the "All Records without Headers" or "Selected Cells without Headers" to accomplish this.

 

G.png

Garrett
11 - Bolide

First thing that comes to mind as a workaround would be to insert a Dynamic Rename tool immediately prior to the Output Data tool.  Configure it to 'Take Field Names From First Row of Data'.

pcatterson
11 - Bolide

One potential issue would be if the first row of data had any duplicates in it.  You cannot have duplicate names for headers and then your excel wouldn't be 100% what you started with.

Garrett
11 - Bolide

What about sending the data through a Table and Render tool?  Might have to spend some time dialing back the formatting, but the Table tool lets you decide whether or not to 'Show Column Headings'.

Labels