Page History

Icon

Input source

Description

Delimited file

This input method is used when extracting data from a delimited file (that is, a file with separators).

Freehand SQL

Use this method to import data from a database using an SQL query.

Report

Use this method to use a Yellowfin report as the source of data.

Single table

This input step can be used to import data from a single database table.

Single third party connector

To extract data from a third-party connector, such as Twitter, Facebook, Google Analytics, etc.

Aggregate Step

This step summarises data including the ability to count, sum and average metric fields.

Calculated Field

This step creates a calculated field based on other fields in the step.

Filter

This step is for filtering data in a step.

Merge

This step merges two sets of data based on the configured Join Fields.

Split

This step duplicates an input dataset to create identical output datasets.

This outputs data to a selected writeable data source. There are multiple options to create and manage tables and indexes, and to insert or update data.