# Automation Designer - Export Dataset Headers Matching Case in Query

**URL:** <https://forums.toadworld.com/t/automation-designer-export-dataset-headers-matching-case-in-query/51876>\
**Category:** Idea Pond\
**Created:** [January 6, 2021, 8:50pm UTC](https://forums.toadworld.com/t/automation-designer-export-dataset-headers-matching-case-in-query/51876 "2021-01-06T20:50:22Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![rvaswani](https://avatars.discourse-cdn.com/v4/letter/r/d78d45/32.png) [@rvaswani](https://forums.toadworld.com/u/rvaswani)\
**Post date:** [January 6, 2021, 8:50pm UTC](https://forums.toadworld.com/t/automation-designer-export-dataset-headers-matching-case-in-query/51876/1 "2021-01-06T20:50:22Z")

</div>

I'd like to be able to export dataset headers from the automation designer in the exact case as specified within the query.

Currently, the default is all caps which can be overridden to all lowercase however some vendor data feeds require headers to match their specs (Barnes and Nobles in this case) and support said this is not possible. Please consider adding this function. Thanks

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [January 6, 2021, 9:08pm UTC](https://forums.toadworld.com/t/automation-designer-export-dataset-headers-matching-case-in-query/51876/2 "2021-01-06T21:08:56Z")

</div>

You can make the column names whatever case you want by aliasing them in your query.

For example:

Select owner as "Owner", table\_name as "TaBLe\_NAMe"  
from dba\_tables;

---

<div class="post-metadata">

**Author:** ![rvaswani](https://avatars.discourse-cdn.com/v4/letter/r/d78d45/32.png) [@rvaswani](https://forums.toadworld.com/u/rvaswani)\
**Post date:** [January 6, 2021, 10:01pm UTC](https://forums.toadworld.com/t/automation-designer-export-dataset-headers-matching-case-in-query/51876/3 "2021-01-06T22:01:01Z")

</div>

Hi John,  
Exactly what I did was use aliases however in grid view, manual export to csv and in automation designer - export dataset it changes the headers case to all caps regardless of alias mixed case. The only option available is all lowercase in the export dataset screen. Support case 4821414 said that is not possible.

This SQL:  
SELECT ROWNUM "0",  
'QCC' campus,  
'' school,  
SUBJECT institutionDepartment,  
CLASS\_TBL.STRM term,  
SUBJECT department,  
CATALOG\_NBR course,  
TRIM(CLASS\_SECTION) || ' ' || SSR\_COMPONENT section,  
'Queensborough Community College' campusTitle,  
'' schoolTitle,  
'' institutionDepartmentTitle,  
DESCRIPT courseTitle,  
'' institutionCourseCode,  
-- (((TRIM (SUBJECT) || '-') || TRIM (CATALOG\_NBR)) || ' ')  
-- || TRIM(CLASS\_SECTION) || ' ' || SSR\_COMPONENT  
'' institutionClassCode,  
SUBJECT institutionSubjectCodes,

exports all cap headers:

 ![2021-01-06_16-59-44](https://global.discourse-cdn.com/quest/original/2X/a/ab51925dab0f63a188012b3ea1b7257902d99ad0.jpeg)

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [January 6, 2021, 10:03pm UTC](https://forums.toadworld.com/t/automation-designer-export-dataset-headers-matching-case-in-query/51876/4 "2021-01-06T22:03:57Z")

</div>

Put double-quotes around your aliases, then case will be preserved. This is really more Oracle behavior than Toad behavior.

SELECT ROWNUM "0",  
'QCC' "campus",  
'' "school",  
SUBJECT "institutionDepartment",....

---

<div class="post-metadata">

**Author:** ![rvaswani](https://avatars.discourse-cdn.com/v4/letter/r/d78d45/32.png) [@rvaswani](https://forums.toadworld.com/u/rvaswani)\
**Post date:** [January 6, 2021, 10:07pm UTC](https://forums.toadworld.com/t/automation-designer-export-dataset-headers-matching-case-in-query/51876/5 "2021-01-06T22:07:50Z")

</div>

Thank you, John!!! Made my day 😉

Not a huge Oracle person used to be more MS SQL server but had to get back in to expedite this project. Thanks again!