Like what you see? Have a play with our trial version.

Error rendering macro 'rw-search'

null

Versions Compared

Old Version 5

changes.mady.by.user user-3484a

Saved on

compared with

New Version 6

changes.mady.by.user user-3484a

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The Data Transformation module supports different ways of extracting data from sources and loading it into Yellowfin, using the input steps. This section will show you how to use and configure each of these steps.

 

Section
Column

Column

Anchor
menu
menu

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.

 

Anchor
delimitedfile
 
delimitedfile

Delimited File

 

  1. Drag the Delimited File option from the input step list. 



  2. Configure the step to extract data from the file. Use the table below to understand the different fields in the Configure panel.

    Expand
    titleDelimited file configuration fields
    Configuration SettingExplanation

    Protocol

    Choose the file protocol here. For example, you can define if this is a local file, a file on the shared network, FTP or SFTP.

    File path

    Enter the path to the file.

    Advanced settings

    This link reveals more setting options, discussed below.

    First row contains unique titles

    Enable this toggle switch if the first row of the file contains titles or column names. If switched on, the system will read these values as the column field titles.

    Field separator

    Choose a character from the list to set it as the field separator, or enter a custom one after selecting the Other option.

    Decimal separator

    Choose a character from the list to set it as the decimal separator, or enter a custom one after selecting the Other option.

    File encoding

    Select a file encoding option.

    Precision

    		 





  3. Then click Apply. Data extracted from the file will appear in the data preview panel.

    Image Modified


    Styleclass
    ClasstopLink

    back