The Basic Control Spreadsheet

Search Knowledge Base by Keyword

< Back

As discussed in the process overview, a data subsetting job starts with the creation of the Basic Control Spreadsheet. This simple spreadsheet defines a Basic Subset. It points the automated VIP workflow to the Source Database that will be subsetted, and specifies the Target Database and Schema.

To configure the BasicControl Spreadsheet, open the Basic Subset Control SpreadSheet that you copied into your Subset folder. The spreadsheet is called “VIPSubset.xlsx” by default. You can rename it.

There are two mandatory sheets in the Basic Control Spreadsheet:

  1. The Configuration sheet
  2. The SQLCriteria sheet

There are two additional, optional sheets that can be populated at this point:

  1. FoundCriteria
  2. SoftKeys

Instructions for completing the four sheets and running a Basic Subset are provided in this subsection. The next section sets out how to perform the Basic Subset Actions based on these sheets.