Trying to insert header names, overwriting previous headers

[wonka1234]

Im trying to insert these headers:

Above here:

trying to union it:

but now im missing my original headers:

How can I fix this?

[Carlithian]

I dont have a clear picture of what you want it to look like, can you mock it up in excel?

[wonka1234]

@Carlithian 

output should have original headers like so:

Output Expected

	Client Name
	Emp Detailed Report
						Alteryx Report
EmpId	Name	JobTitle	Years od Service	County	Location	Email	Ph no	Account	Project Code	Interco Segment	Future Value
1	a	p	5	Ind	xyz	abc	123	100	1	0000	0
2	b	q	6	Ind	xyz	def	234	101	1	0001	0
3	c	r	7	Ind	xyz	pqr	456	102	1	0002	0
4	d	s	8	Ind	xyz	qwe	567	103	1	0003	0

[Carlithian]

hmmm, don't see where they would come from in the screenshots, but considering your tool config what is going on is its taking input one (your feed with the f1 f2 etc headers) then the putting the other data below it. Since you have config by position it will decide that 'less than a month' is now f2, as it was in the second column

If you want it to be 'less that two months' instead of f2, then you need to flip the #1 and #2 order in the config

If that isnt what you are going for, you will likely want to go down the dynamic rename route

[binuacs · Accepted solution]

@wonka1234 One way of doing this with the Report Text tool and the table tool

[Sarreddy]

@wonka1234 

[grazitti_sapna]

@wonka1234 , you can use the report text tool and align the headers the way you want them  in your output file and then union it with rest of the data and output the data to excel using render tool as below.

[wonka1234]

@binuacs  when unioning the two tables I get this result

[Sarreddy]

@wonka1234 

if I'm exporting the data in .yxdb file format I can able to see data as per your requirement PFA screen shot FYR.