Saving Column Layouts with Scraper

Getting Started #

If you rearrange and/or delete columns after downloading a Table then make sure to use the Scraper button to save the new layout. If you do not save the layout and download the Table again then it will revert to the old layout.

Saving the Layout #

With your Table downloaded and columns adjusted follow the steps below.

Click the Edit Query button on the ribbon.

The current SQL Statement still shows GLDB.* which means all columns.

Click the Select button on the left side.

You will see the current Selected Columns.

Click the bottom button on the right side.

You will receive the prompt below.

Click the OK button.

The Selected Columns will now be updated to match the layout of the table in the worksheet.

Click the Save Changes button.

The SQL Statement field will also be updated with the new layout.

Click the Download Changes button to save the changes and download fresh data.

Click the Save Changes button to save the changes.