output data to excel with customized header

[aeolus187]

Hi alteryx engineers,

how can we output data to excel with customized header like below? I have data need to populate into the green area, the column is started from row 3, and there are duplicated column name in one sheet. how can we achieve this?

[Qiu]

@aeolus187 
You can use the output tool with range and ignore the header.

[NikyN]

Hello @aeolus187,

I would got with Render Tools to make it more dynamic (so in case any field name change/or will be added -- it will be automatically considered.

I would treat My Data and Cust Data as separated tables, where you can add the "header" (first 2 rows as in excel). Once both tables prepared --- I would use layout tool to bring these two tables together.

I agree with @Qiu, if your headers/columns won't change - the range solution is more effective (but have template prepared).

Best Luck!

NN