Before we renamed the columns in the last section, we mentioned three big rules. The second rule is removing unnecessary columns. You can right-click on a column and select Remove to delete the column, like you do in Excel. You can even highlight the columns you want to keep and right-click and Remove Other Columns. We do not like this method. It's tedious and doesn't allow for easy editing using the gear in the APPLIED STEPS. Instead, we prefer using the Choose Columns option.
Let's remove all the unnecessary columns on the Vendors
query. We'll need to make sure to keep the columns that have already been used:
In Query Editor, select the query
Vendors
in the Queries pane.Select Choose Columns icon on the Manage Columns section of the Home tab:
The Choose Columns window will open. Unmark (Select All Columns) to unmark everything, and then mark the following columns:Vendor ID, Vendor Name, Address 1, Address 2, City, State, Zip Code, 1099 Type, Current Balance...