Im trying to insert these headers:
Above here:
trying to union it:
but now im missing my original headers:
How can I fix this?
@wonka1234 One way of doing this with the Report Text tool and the table tool
I dont have a clear picture of what you want it to look like, can you mock it up in excel?
@Carlithian
output should have original headers like so:
Output Expected
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 configIf that isnt what you are going for, you will likely want to go down the dynamic rename route
@wonka1234
@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.
@binu_acs when unioning the two tables I get this result
@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.
