Menu | Description |
|---|---|
Select File | Select a file. The maximum file size is 256MB. |
File Type | Enter file type that you want to import. |
File Password | If your file is password protected, enter the file password. |
Sheet Name | Enter the sheet name you want to retrieve from the specified spreadsheet. Ensure to verify the sheet name for accidental spaces. First sheet of the workbook will be used if the field is blank. |
Update method | When Domo retrieves your data from the source, you can determine how new the data is imported into the current DataSet. You can select Append or Replace from the drop-down list.
|
| Field | Description |
| Layout | Select the Layout. |
| Mode | Select parsing options from the drop-down list.
|
| Column Header Range | Enter the range of cells which will be used as headers (for example, A2:F8). This field appears if you select the Mode as Manual . |
| Data Range | Enter the range of cells which will be used as data (for example, A3:F20). This field appears if you select the Mode as Manual . |
| Include Phonetic Data | If you want to append Phonetic data, then select True , or select False . By default False is selected. |
| Row Header Range | Enter the range of cells which will be used as headers (for example, A2:A8). This field appears, if you select the Layout as Row As Header and the Mode as Manual . |
| Delimiter | Select the character used by your character-separated values (CSV) text to separate your columns. If your delimiter is not listed select 'Other'. |
| Specify Your Delimiter | Enter the character used to delimit your character-separated values (CSV) text. This field appears when you select Other from the Delimiter drop-down list. |
| Quote Character | Select the desired quote character for parsing CSV files. (Double quote is the default quote character for CSV standard) |
| Custom Quote Character | Enter the desired CSV Quote character. This field appears when you select Other from the Quote Character drop-down list. |
| Escape Character | Select the desired escape character for parsing CSV files. |
| Custom Escape Character | Enter the desired CSV escape character. This field appears when you select Other from the Escape Character drop-down list. |
| Detect Encoding | Select Yes to auto detect file encoding and No to manually select the encoding. |
| File Encoding | This option appears if you select No from the File Encoding drop-down list. |
| Add Filename Column | Specify if *BATCH\_FILE\_NAME* column should be added to the final output or not. |
| Header Start Row | Enter the row number from where the header starts. |
| Data Start Row | Enter the row number from where the data starts. |
| Footer Rows To Skip | Enter the number of rows at the end of the file to skip. For example, to skip the last two rows you should enter 2 . |
| Date Format | Select the date format that should be used when you want to convert date columns.(For excel files, date format specified for the cell will have higher precedence). |
| Blank Rows | If you encounter blank rows, either select Skip blank rows or Stop at the first blank row . |
| Empty Column Headers | If you encounter, empty column headers, either select Add blank columns or Stop at the first blank column . If you choose Add blank columns , the column names are automatically generated for the new columns. |