Deleting Columns from a Worksheet

While you were rearranging and formatting the column headings, you may have spotted a column that is unnecessary. You may have included something that has no bearing on the desired final result. For example, Global Widgets always ships what is ordered. Including Order Qty and Ship Qty in the same query would be redundant, and you could remove one of them.

Another reason for removing a column is when the sole purpose for including it was to enable the column to be used in a calculation or condition. Now is the time to get rid of these columns. Do not worry about your calculations or conditions, as Discoverer will remember which columns were used and will continue using them after you have deleted them from the output. This holds true even when the item being deleted was the only item being selected from a folder. We think this is a really clever feature. This will be explained in detail in Chapter 12.