This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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).
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.
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.