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

Toad Data Point
1

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?

2

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
image1181×693 118 KB

3

Got it! Thanks, Gary!