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

Error rendering macro 'rw-search'

null

Versions Compared

Old Version 27

changes.mady.by.user Yellowfin

Saved on

compared with

New Version 28

changes.mady.by.user Yellowfin

Saved on

Key

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

...

From here you will be taken to the CSV File page, where you will need to locate and load the CSV file.

Expand
titleClick to Expand Instructions
Section
Column
width30%

1. Either click on the Browse Files link, or the CSV image to locate your file, or drag your file from the file system onto the grey area.

Column
width70%

Image Modified

Section
Column
width30%

2. Once selected, Yellowfin will confirm that the file has been uploaded.

Column
width70%

Image Modified

Section
Column
width30%

3. From here, if you have Advanced CSV Settings permissions, you can click on the Advanced Settings link, otherwise progress to step 4.
Advanced Settings include:

  • Data Source - this allows you to select the writable data source you wish to import the CSV data into.
  • View Category - this allows you to select the view category to store the CSV view, Yellowfin will create, into.
  • Field Separator - this allows you to specify which character is used in the CSV to separate values in the case that it's not a comma. If Other is selected, you can type your own character.
  • Precision - this allows you to define how many rows of the CSV Yellowfin will examine in order to define the field types and size.
    • Low Precision is fast, and only examines the first 1000 rows of the file.
    • High Precision is slower, depending on the size of the file, as it examines all rows.
Column
width70%

Image Modified

Section
Column
width30%

4. Once complete, click the Next button to progress to the formatting step.

Column
width70%

Format & Configure Data

Styleclass
ClasstopLink

top

...

These options are available outside of the Data Step menus.

...

titleClick to Expand Details

Column Titles

By default, Yellowfin assumes that the first row of your CSV contains the text to be used as column titles, rather than data itself.
To change this option you can uncheck the First row contains unique titles option at the bottom-left of the page.
This will take the first row of the CSV and treat it as data, allowing you to provide your own labels.
Image Modified
If you wish to change some or all of the column titles displayed, there are two methods you can use.

  1. You can click on the title, which will select it and allow you to enter new text, or
    Image Modified
  2. You can access the Column Formatting menu and change the Title there.

Rows

This allows you to change the number of rows previewed.

Refresh

This allows you to refresh the data displayed in the preview.

Field Drop Down Menu

This menu is accessed by clicking on the blue arrow on a Column Title.

Click to Expand Details
Sectionexpand
Column
title
width3%

Image Modified

Column
width97%

Convert to Text Field

This allows the contents of the field to be treated as text, changing the functionality that's available to it from numeric or date to text. This option is only displayed on fields not recognised as text natively.

Field Type

This allows you to change the field from a Metric to a Dimension or Geography, or from a Dimension to Geography.

Index

This allows you to add an index to the field in order to increase read performance. Generally, indexes should be added to fields that will be used in joins or filters.

Drill To

This allows you to define a Dimension field to Drill Down to.

Format

This opens the Column Formatting menu, allowing you to apply default formatting options and apply meta data to the field.

Default Aggregation

This allows you to assign a default aggregation to be applied to the Metric field when added to reports. This can be overridden in the Report Builder.

Copy

This allows you to create a duplicate copy of the field, which can then be formatted, converted, or changed separately to the original.

Column Formatting

Defining field meta data and formatting is an important part of View creation and as such, an important part of the CSV import process. The Column Formatting menu provides you with a range of options depending on the field type.

...