Table of Contents
Adding Tables From a Text/CSV File
Send comments on this topic.
Follow the steps below to add tables from a text/CSV file.

- Navigate to Add Data and select CSV file  Then, select the required file.

- In the Data Properties window, set required settings.

 

Component Description
1 The delimiter separating the values in the files
2 Use the first row in the data as names of fields
3 Ignore first and/or last rows according to criteria
4 Show\Hide fields from the preview window
5 Preview the data
6 Define the culture that will be used when parsing dates, numeric values and currencies

 

Before you click ADD to complete the process, make sure field types are set correctly.  The type of a field directly affects the type of Dimensions created on it, and therefore affects the type of analyses it can be used with.  The type of field is indicated by an icon which is placed next to its name in the Preview box:

Icon Meaning

Text field
Numeric field
Date/Time field

In some scenarios, the automatically assigned type for a field may be incorrect.  If this happens, you can change the field’s type manually by right-clicking the field header and setting the correct field type.