transformations:importfixedwidthtext
no way to compare when less than two revisions
Differences
This shows you the differences between two versions of the page.
Previous revisionNext revision | |||
— | transformations:importfixedwidthtext [2021/03/10 14:26] – [See Also] dmitry | ||
---|---|---|---|
Line 1: | Line 1: | ||
+ | {{ transformations: | ||
+ | ======IMPORT FIXED WIDTH TEXT FILE====== | ||
+ | (Category: //Import | File//) | ||
+ | =====Description===== | ||
+ | This transformation imports text files with columns of fixed width. The width and name of every column have to be defined explicitly in the transformation properties. | ||
+ | |||
+ | Use the __preview pane__ (click the //Show preview// button) to visually split text into columns. Click a character in the preview to create a splitter. Drag a column splitter left or right to adjust the column width.\\ | ||
+ | \\ | ||
+ | =====Action Settings===== | ||
+ | ^Settings^Description^ | ||
+ | |Load file|Fully-qualified file name of the dataset (includes relative or absolute path).| | ||
+ | |Encoding|ASCII, | ||
+ | |First loaded line contains headers|Check this " | ||
+ | |New columns|Refer to the table below for //new column// settings.| | ||
+ | |Put remaining symbols into column|Check " | ||
+ | |||
+ | ^**//New columns// settings**^^ | ||
+ | ^Settings^Description^ | ||
+ | |Add more columns|This button will open a list where the columns in the imported file can be explicitly defined by Name and Width.\\ | ||
+ | |Name|The names to be assigned to the incoming columns.| | ||
+ | |Width|The size, in characters, of the column. | ||
+ | |||
+ | \\ | ||
+ | =====Advanced options===== | ||
+ | ^Settings^Description^ | ||
+ | |Decimal|Select whether decimal points are represented by a point (.) or comma (,).| | ||
+ | |Skip first lines|Defines the number of rows in the incoming dataset to skip before importing data. Use this in cases where\\ leading rows may contain blank rows or metadata not to be included in the dataset.| | ||
+ | |Maximum number of lines to load|The maximum number of rows to be imported. | ||
+ | |||
+ | {{transformations: | ||
+ | |||
+ | =====Importing Multiple Files===== | ||
+ | This action can import multiple files. | ||
+ | \\ | ||
+ | =====Use cases===== | ||
+ | Use the '' | ||
+ | \\ | ||
+ | If your data has __delimeters__, | ||
+ | \\ | ||
+ | =====Examples===== | ||
+ | **Example 1:** You are importing data from a legacy system' | ||
+ | < | ||
+ | Name Address | ||
+ | John Hardy 111 Any Street | ||
+ | Amanda Smythe | ||
+ | Rick Johanssen | ||
+ | </ | ||
+ | //Use the following settings to import this dataset:// | ||
+ | > Column settings: | ||
+ | > (column 1) Name: " | ||
+ | > (column 2) Name: " | ||
+ | > (column 3) Name: " | ||
+ | > (column 4) Name: " | ||
+ | > (column 5) Name: " | ||
+ | > First loaded line contains headers = " | ||
+ | //For safety, we will add a column to capture overflow characters:// | ||
+ | > Put remaining symbols into column = " | ||
+ | //Ouput dataset:// | ||
+ | ^Name^Address^City^ST^Zip^ | ||
+ | |John Hardy|111 Any Street|Boston|MA|02110| | ||
+ | |Amanda Smythe|16 East Valley Lane|Hanover|MD|21076| | ||
+ | |Rick Johanssen|14 Sunset Ave, Apt 16B|Delaware City|DE|19706| | ||
+ | |||
+ | |||
+ | \\ | ||
+ | **Example 2:** You are presented with survey data that has been captured incorrectly - all values have been compressed into a single field. | ||
+ | < | ||
+ | 12345 | ||
+ | 14324 | ||
+ | 11232 | ||
+ | 45455 | ||
+ | 34234 | ||
+ | 55234 | ||
+ | </ | ||
+ | //To expand these response values into their appropriate columns:// | ||
+ | > Column settings: | ||
+ | > (column 1) Name: " | ||
+ | > (column 2) Name: " | ||
+ | > (column 3) Name: " | ||
+ | > (column 4) Name: " | ||
+ | > (column 5) Name: " | ||
+ | |||
+ | //Output dataset:// | ||
+ | ^1^2^3^4^5^ | ||
+ | |1|4|3|2|4| | ||
+ | |1|1|2|3|2| | ||
+ | |4|5|4|5|5| | ||
+ | |3|4|2|3|4| | ||
+ | |5|5|2|3|4| | ||
+ | //(In this case, you could also have used the// '' | ||
+ | |||
+ | \\ | ||
+ | =====See Also===== | ||
+ | |||
+ | * [[transformations: | ||
+ | * [[transformations: | ||
+ | * [[transformations: |
transformations/importfixedwidthtext.txt · Last modified: 2021/08/14 21:24 by craigt