The Pre-Screening: File Wizard

The Pre-Screening: File Wizard assists you in the early detection of data errors. Use it to verify flat files before loading them into another system.

The source file can be any structured text file with data items arranged in fixed-width columns or organized with separators, such as | or ;.

Run Pre-Screening tests

To perform Pre-Screening: File tests, follow the steps below:

1. Ensure that your Pre-Screening TestCase templates are located in the _Tosca BI Templates folder.

   If you want to use a template that you have created manually, make sure to move it to the _Tosca BI Templates folder.

2. Open the Pre-Screening: File Wizard: Select a BI folder and click theFile icon in the dynamic menu BI Testing.

   Alternatively, you can right-click a BI folder and select Tosca BI->Pre-Screening: File from the context menu, or press CTRL+W, CTRL+F.

3. In the Tosca BI TestSheet properties dialog, click Yes.

4. The Wizard guides you through the TestCase creation: 

   • Step 1 - Source File Definition

   • Step 2 - Test Selection

   • Step 3 - Template Selection

5. If you have performed Step 3 - Template Selection in its entirety, you can now execute your tests.

   If you have not performed Step 3 - Template Selection in its entirety, you must take additional steps. For more information, see chapter "Step 3 - Template Selection".