Skip to content

Exploring Transformation Results#

The 'Explore' feature enables you to understand the structure, content and lineage of your datasets. You can explore from any dataset that is displayed in the Flow Area, e.g. after preparing your data, you would like to explore the transformation results.

Data exploration can be viewed and performed from the 'Explore' tabs and provides validation and exploration options like:

  • Filtering: for adding filters or finding values within a dataset
  • Aggregate: to summarize a dataset
  • Sorting: to sort a dataset

Each exploration can be performed combined at once or in an own 'Explore' tab that is named with an increasing number for each tab, e.g. 'Explore', 'Explore2'.

Exploring Via Filtering#

You can filter your created view in search of specific values in order to validate your transformations afterwards, e.g. you applied the 'Manage Columns' operation to your source and created the view and now want to check whether a certain value is included. To perform an exploration, just click on the required node in the Flow Area. You can apply one or multiple filters on a node.

To filter:

  1. In the Data Grid, starting from the "Preview" or "Explore" tab, click on "Explore". The dialog 'Explore Results' opens.

  2. Click on "Filter". The 'Filter' section collapses.

  3. Select the column, enter the operator and the filter value.

  4. If you don't want to apply another filter, confirm with "OK". Otherwise select the next column, operator, value ... The filter applies. The results are shown in the respective 'Explore' tab in the Data Grid.

Exploring Via Aggregating#

You can summarize your results by dimensions and measures to validate your data. Summarizing can be done for zero or more columns:

  • you don't have to summarize by any dimension but can still aggregate which is great for grant total summarization queries
  • you don't have to aggregate by anything but still can group by any number of dimension which is great for seeing distinct dimension values

To aggregate:

  1. In the Data Grid, starting from the "Preview" or "Explore" tab, click on "Explore". The dialog 'Explore Results' opens.

  2. Click on "Aggregate". The 'Aggregate' section collapses.

  3. Select the dimension and measures from the drop-down and the function.

  4. If you don't want to apply another aggregation, confirm with "OK". Otherwise select the next dimension, measure ... The aggregation applies. The results are shown in the respective 'Explore' tab in the Data Grid.

Exploring Via Sorting#

You can sort your data according to your needs, e.g. sort a specific column with regard to ascending values.

  1. In the Data Grid, starting from the "Preview" or "Explore" tab, click on "Explore". The dialog 'Explore Results' opens.

  2. Click on "Sort". The 'Sort' section collapses.

  3. Select the column, direction and if needed the limit and confirm with "OK". The sort applies. The results are shown in the respective 'Explore' tab in the Data Grid.

Downloading Data#

You can download the dataset from each 'Exlore' tab. Find more information here.