Create Double Headers in Excel

[BRRLL99]

Hi

I have following headers have been generated in Alteryx
NOTE: random data has been used

DR/CR	COUNT CODE	GROUP MEM	BRCH	SERIAL	SXX	RRY	AMOUNT	DATE	ITEM	CODE	CTCD	GMAB	BRCH_	SERIAL_	SXX_	M1	M2	M3
763	602	295	776	995	409	262	610	12-2-23	607	717	199	HHRH				586	970	955
317	624	535	146	771	835	906	651	12-3-23	193	598	283	HHRH	895	794	101	600	550	168

In the Excel output I was looking for ( Excel output should have exact header output)

			Acc NO			Transaction	Transaction		S/E	TRSS	Associate data
DR/CR	COUNT CODE	GROUP MEM	BRCH	SERIAL	SXX	RRY	AMOUNT	DATE	ITEM	CODE	CTCD	GMAB	BRCH_	SERIAL_	SXX_	M1	M2	M3
947	173	860	824	163	711	910	800	12-2-23	572	419	589	HHRH				112	986	893
693	633	265	307	969	736	361	985	12-3-23	327	255	151	HHRH	285	620	164	759	952	341

[cjaneczko]

Easiest way to do this is create a template in excel and save it, provided that the very first header row is always in the same spot. Then have Alteryx start its output on Row 2 with the next header. Set the output to preserve formatting and set the range to start from A2 onward. 

There are other ways to go about it, but this will be the simplest. 

[BRRLL99]

demand wise i have create multiple files in a day.

can please show other models?

[cjaneczko · Accepted solution]

Create a text input with the first header. Use a union tool to union the first header, second header, and then the final data. In the Union tool, select field position instead of common field names. On the output tick the box that says to ignore the field names.