Writing Clear Specifications

From DataSelf Knowledge Base
Jump to navigation Jump to search


Example 1

Change the SQL View that is used in the Excel AD Controller workbook:

E:\Program Files (x86)\DataSelf\ExcelDistribution_YDT Sales Report\DS_ExcelADController_YTDCustomerSalesActivity_BySalesPerson.xlsm

Such that, for example:

The Target file that is currently being written to:
E:\Program Files (x86)\DataSelf\ExcelDistribution_YDT Sales Report\Target\Monthly YTD\John Doe_Sales Report.xlsx
Instead is written to:
E:\Program Files (x86)\DataSelf\ExcelDistribution_YDT Sales Report\Target\Monthly YTD\<region-name>\John Doe_Sales Report.xlsx
WHERE:
<region-name>   is one of   {'East', 'West', 'Central', 'OEM'}