Output as Append to Existing when the headers in Excel begin on 2nd row

I'm outputing data from a workflow into Excel. The first row in Excel is one long merged row over several columns so the headers begin on the 2nd row. I'm using Append to Existing since I'll continue to add data. The error message is stating that the incoming field name cannot be appended because Alteryx is looking at the first row and it doesn't exist. I've tried creating a dummy row but that won't help. The header names must start at the second row. Any input would be appreciated.

Accepted answers

Ladarthure

Yes sure thing, you can add something like this :

filename.xlsx|||Sheet1$A2:ZZ9999999

with $A2:ZZ9999999 as the range in your formula where you define the path and it works perfectly !

All comments

Ladarthure

hi @bleu,

you can also on the input tool choose to skip the n first lines, allowing you to skip this first line, is this what you meant?

bleu

Not quite. I have a lot of reports that I constantly have to do that. When I bring them as an input to Alteryx I have to specifiy which line to start on. But this is an ouput. I want to specifiy in the output where I want the headers to start.

Ladarthure

in the output tool, you can select a specific range just after selecting the xlsx option. (see screenshot below). If you don't know the exact range, you can set a bigger range that what is needed.

bleu

I should have also mentioned that I'm using a file path for these outputs. I've got a formula that creates a file path and based on the month, year etc. the outputs automatically go into their appropriate folders. So it won't just be one excel file in a permanent location. It will be different excel files (by month/year etc) that have the same Excel format in different locations.

Can I still do this if I'm changing the file paths and how?

Ladarthure

Yes sure thing, you can add something like this :

filename.xlsx|||Sheet1$A2:ZZ9999999

with $A2:ZZ9999999 as the range in your formula where you define the path and it works perfectly !

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335