Preserve SQL Column Names in Export to Excel
but take a look at:
Thank you Patrick. Two of us googled for answers, and neither of us found that one.
I struggled to get this working. I discovered that the SQL script populates variable ‘globalfilePATH’ but the script to rename the columns is using ‘globalfileNAME’. The script bombs. I changed the SQL script to populate ‘globalfileNAME’ that the second script is looking for. It works perfectly now! Thanks again!
If you would like to submit an answer or comment, please sign in to the eOne portal.