community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Write an Excel output Without a Headerline

Alteryx Partner

Hello, 

 

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

 

Regards Humberto 

ACE Emeritus
ACE Emeritus

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

Alteryx Certified Partner

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'.

ACE Emeritus
ACE Emeritus

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.

Highlighted
Alteryx Certified Partner

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