|Uploading tables | Upload a table (advanced upload) ||
Descriptions for fields and options in the File Information section of the Advanced Uploader tab.
The tables in this topic explain the fields and options available in the File Information section of the Advanced Uploader tab.
File Information section
|File Type||The format of data in the file (table).
|Field Delimiter||The character used to separate each field (column) in the record (row) of the
file (table). This field displays when Delimited is selected
from the Type drop-down list.
|Other Delimiter||The character other than a comma, tab, or pipe that is used to separate each
field (column) in the record (row) of the file (table).
This field only displays if Other is selected in the Field Delimiter drop-down list.
|Record Delimiter||The delimiter used to indicate the end of a each record (row) in the file
(table). A delimiter is a sequence of one or more characters used to specify the
boundary between separate, independent regions in plain text files. In general, the
two most commonly used record delimiters in the Insights Platform are CRLF and LF.
|Ignore Nulls||Determines how the Insights Platform treats a null character in an upload file.
|# of Records to Skip||The number of records (rows) to skip when uploading the file (table).
For example, the first row of a table usually contains names and not data. To exclude the first row of the table in the upload, enter 1. When the file is uploaded, the Insights Platform will ignore the first row in the table and start uploading the data beginning with row 2.
|Load||The total number of records (rows) in the file (table) to upload.
For example, to include only the first 100 rows of the table in the upload, enter 100. The Insights Platform will upload the first 100 rows in the table and then ignore any rows that follow.
The advanced options provide additional settings for input file handling and data structuring in the 1010data Insights Platform.
To view these additional fields, click Advanced Options.
|Masking Character||The character used to encapsulate fields that may contain the delimiting
character. By default, the Insights Platform uses the quotation mark ( " )
For example, a field of text data may also contain a comma—a common field delimiter. To prevent the Insights Platform from splitting the data field at the comma, that field needs to be surrounded by the indicated masking character.
Note: If this field is left blank, the Insights Platform uses the quotation mark ( " ) for the masking character. To set the masking character to none, enter \0.
|Masking Width||The maximum number of characters within a masked field that the Insights
Platform will consider when identifying field delimiter characters to ignore. The
default maximum masking width is 1000 characters.
For example, if a masked field is 2000 characters in length, but the maximum masking width is set at 1000, only the field delimiter characters that occur within the first 1000 characters of the field are ignored. Any field delimiter characters after the first 1000 characters will be treated as a standard field delimiter.
|Rows Per Seg||The maximum number of records (rows) in the file (table) to include in a single
segment. The default is 5 million rows and, in general, should not be
However, if the uploaded table will be used for aggressive expanding purposes, the maximum number of rows in each segment may need to be reduced. Contact 1010data Support to discuss your needs and we will help you determine the appropriate setting.