# Hide column in Transform and Cleanse, but it shows up in my Excel spreadsheet

**URL:** <https://forums.toadworld.com/t/hide-column-in-transform-and-cleanse-but-it-shows-up-in-my-excel-spreadsheet/54325>\
**Category:** Toad Data Point & Toad Intelligence Central\
**Created:** [December 22, 2021, 1:54am UTC](https://forums.toadworld.com/t/hide-column-in-transform-and-cleanse-but-it-shows-up-in-my-excel-spreadsheet/54325 "2021-12-22T01:54:18Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![john.coniff](https://avatars.discourse-cdn.com/v4/letter/j/91b2a8/32.png) [@john.coniff](https://forums.toadworld.com/u/john.coniff)\
**Post date:** [December 22, 2021, 1:54am UTC](https://forums.toadworld.com/t/hide-column-in-transform-and-cleanse-but-it-shows-up-in-my-excel-spreadsheet/54325/1 "2021-12-22T01:54:18Z")

</div>

In my T&C file, I have a column I use to sort my query results. In "Show/Hide Columns" I de-select the column because I don't want it in my output. In my Auto Script, I call the T&C file and output the results to an Excel spreadsheet. The "hidden" column is part of the output! I re-open the T&C file, and the column is checked (selected). What do I need to do to not have this column show up in my output?

---

<div class="post-metadata">

**Author:** ![Gary.Jerep](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/gary.jerep/32/205_2.png) [@Gary.Jerep](https://forums.toadworld.com/u/Gary.Jerep)\
**Post date:** [December 27, 2021, 9:00pm UTC](https://forums.toadworld.com/t/hide-column-in-transform-and-cleanse-but-it-shows-up-in-my-excel-spreadsheet/54325/2 "2021-12-27T21:00:02Z")

</div>

Hey John,

Simply change the underlying query that the T&C engine is using to retrieve the data, per below. I just tested this out directly from T&C, and from an automation script, and works nicely.

 ![image](https://global.discourse-cdn.com/quest/original/2X/7/7a6c2dc347449e131b3920ca8f2140ec6fa70c76.png)

---

<div class="post-metadata">

**Author:** ![john.coniff](https://avatars.discourse-cdn.com/v4/letter/j/91b2a8/32.png) [@john.coniff](https://forums.toadworld.com/u/john.coniff)\
**Post date:** [January 13, 2022, 9:48pm UTC](https://forums.toadworld.com/t/hide-column-in-transform-and-cleanse-but-it-shows-up-in-my-excel-spreadsheet/54325/3 "2022-01-13T21:48:45Z")

</div>

Got it! Thanks, Gary!