OutputTo or TransferSpreadsheet?

[misternumbertwo]

Hi Everyone,

Been a while since I last posted a question here but now I really need somebody's help. I've got two different queries and I want to export them into a single file. I know I've got two options which are OutputTo and TransferSpreadsheet but here's my dilemma.

1. When I use TransferSpreadsheet, I am able to output the two queries in a single excel file however, the field names are not the aliases that I want to appear (i.e. PTReleaseNumber should appear as Release Number on the Column name).
2. When I use the OutputTo command, I am able to export the way I want to but the thing is, I can't seem to make it work that both queries will be on the file. The last query is the only one I can see on the output (I think it overwrites the other one).

Can somebody point me towards the right direction?

Thanks Everybody!

 

[Trevor G]

You can rename the fields in the Query to marry them up, you would basically use an expression see example here:

Release NumberTReleaseNumber