Open an existing Task or create a new one

click on “Next”

The next Screen is split into 2 Parts.

The upper Part gives you the Column Information of the Base Table, the lower Part gives you a preview of the first 100 Records of the base Table.

If you activate a column field in the upper Part, the lower Part will move to this Column and shows the Data Entries for this Column

Filter the Preview Data

click on “Filter Preview Data”

A new Screen pops up, showing you the available Columns and allows you to filter the Preview Data with SQL Syntax

In this Case we will set a Filter to show all Golf-Courses which are located in the city of Neuss

Wilcon DWH Builder will contact the Source Table and gets the Data based on the Filter Criteria