transformations:importtext
Differences
This shows you the differences between two versions of the page.
Next revisionBoth sides next revision | |||
transformations:importtext [2015/01/31 15:00] – created dmitry | transformations:importtext [2018/08/15 08:18] – dmitry | ||
---|---|---|---|
Line 1: | Line 1: | ||
===== Import from delimited text file ===== | ===== Import from delimited text file ===== | ||
- | This transformation | + | This action |
- | File name should include full or relative path. | + | The number of columns in the resulting dataset is defined by the 1st row of imported data. |
+ | **Options** | ||
+ | // | ||
+ | |||
+ | // | ||
+ | |||
+ | //Decimal// - when a text value looks like a number, EasyMorph converts it into a number. The decimal character specifies whether such numbers should have comma or dot as decimal separator. | ||
+ | |||
+ | //Skip first lines// - this option specifies how many lines to skip from the beginning of a file. It can be helpful in case when first rows contain some metadata (file header) and actual tabular data starts only after that metadata. This setting can be specified using a parameter as well. | ||
+ | |||
+ | //Columns don't have headers// - check this if data doesn' | ||
+ | |||
+ | **Advanced options** | ||
+ | |||
+ | //Show parsing errors// - check this to add a column that contains parsing errors (if any) for each line. It can help detect rows that have too few values, or too many values. | ||
+ | |||
+ | //Ignore quoting// - by default, values wrapped in double quotes can contain the separator character and line breaks. Check this option if wrapping double quotes should be treated as regular characters. | ||
+ | |||
+ | //Maximum number of lines to load// - limits the number of rows loaded from the file. This setting is applied after //Skip first lines//. Use 0 to load all rows. | ||
transformations/importtext.txt · Last modified: 2023/10/11 20:48 by craigt