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
