4.2.3 Importing Data Into an Embedded Table

To import data from a delimited text file into an embedded table, follow the steps below:

The size of the embedded table will change to match the number of rows and columns in the imported data.

1. Create a new embedded table, or select an existing embedded table. (Existing data and column names will be overwritten by the imported data.)

2. Right-click the title bar of the embedded table, and select 'Import Data File' from the context menu. This opens the 'Import Data File' dialog box.

 

3. Click 'Select File', and choose the desired text file. (By default, only files with the extension “.csv” are shown. To view all file types, enter “*.*” in the 'File Name' field, and press Enter.)

4. From the 'Encoding' menu, select the encoding of the text file.

5. In the 'Delimiter' field, enter the character that is used in the text file to separate entries. The default delimiter character is a comma. For tab-delimited files, select the 'Tab' option.

6. Adjust any of the following optional settings to modify the way the file data is interpreted:

a. Select 'First Row as Header' to use the entries in the first row of the text file as the column header text. Otherwise, default column names are used (“col0,” “col1,” etc.).

You can only unpivot a crosstab that has a single level of col­umn headers.

b. (Optional) Select 'Unpivot' if the data in the file is in crosstab table form, and you wish to convert the crosstab table into a regular table within the Worksheet. This option will convert the column header row into a “dimension” column and convert the crosstab cells into a “measure” column. If the crosstab table in the file contains multiple levels of row headers, enter the number of levels in the 'Header Columns' field.

c. (Optional) Select 'Remove Quotation Marks' to strip quotation marks out of the text file upon import.

The delimited text is imported into the embedded table, and the table resizes itself to the correct number of columns.

See Also

Unpivoting a Table, to unpivot an arbitrary Worksheet crosstab.

Creating a New Embedded Table, for instructions on adding a new table.

Text Data Source, in Data Modeling, for more extensive text capabilities.

<< 4.2.2 Converting a Regular Table to an Embedded Table © 1996-2013 InetSoft Technology Corporation (v11.4) 4.3 Adding a Table Column >>