Create Double Headers in Excel

BRRLL99 · 2024-03-18T12:28:03+00:00

Hi I have following headers have been generated in Alteryx NOTE: random data has been used DR/CRCOUNT CODEGROUP MEMBRCHSERIALSXXRRYAMOUNTDATEITEMCODECTCDGMABBRCH_SERIAL_SXX_M1M2M376360229577699540926261012-2-23607717199HHRH 58697095531762453514677183590665112-3-23193598283HHRH895794101600550168 In the Excel output I was…

BRRLL99

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

Data Investigation

Accepted answers

cjaneczko

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.

Create Double Headers in Excel.yxmd

All comments

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

Create Double Headers in Excel.yxmd

Quick Links

This months top contributors

mceleavey 383

AkimasaKajitani 382

mbarone 337

Hollingsworth 335

LanisC 335