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

Output data without column headings to Excel

Meteoroid

I want to output a data file to a specified range within an Excel worksheet WITHOUT the column headings.  Is that possible?

Alteryx Certified Partner

I don't think it's possible to omit the field name/header from the Output tool when writing an xlsx file like it is with a csv.

 

I suggest using a Dynamic Rename tool to do this before the Output tool. Set the tool to "Take Field Names from First Row of Data" and that will rename the field names with the first row (effectively omitting the headings from the output). 

Pulsar

Hi @buddy_jones 

 

As usual, @CharlieS has a great solution to a tricky problem.   The only possible problem here is if your first row has duplicate values.  The second of these will be renamed usually with "_2".  You will get a warning in your workflow

 

Another option, unless the requirement specifically calls for excel is to output as csv.  Most users have file associations set so that .csv files open in Excel anyway.  

 

Dan

Meteoroid

Thanks, Charlie.  I think the .csv approach might have worked for me.  I went ahead and created a set of dummy rows in my data file just before the crosstab so that I would get the full set of column headers that I need.  I then filter out the row that contained the dummy data. 

 

Buddy

Labels