Differences

This shows you the differences between two versions of the page.

--- transformations:filesplitter [2021/07/19 01:38] – craigt
+++ transformations:filesplitter [2021/07/19 02:35] – [Examples] craigt
@@ Line 10: / Line 10: @@
 =====Action settings=====
 ^ Setting  ^ Description  ^
-|Input file<sup>*</sup>|Fully-qualified file name of the text file to be split (includes relative or absolute path).|
+|Input file<sup>*</sup>|Fully qualified file name of the text file to be split (includes relative or absolute path).|
 |Encoding|ASCII, ANSI (with code page), and other types of encoding. If you're not sure what to choose, try UTF-8 as it's the most\\ common Unicode encoding.|
 |Skip first lines<sup>*</sup>|This option specifies how many lines to skip from the beginning of a file. It can be helpful in cases where the 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.|
@@ Line 33: / Line 33: @@
 **Example 1:**  Splitting a comma-delimited text file with 10,000 rows, and splitting every 1,000 rows.\\
-**Action settings:**
+\\
+**Action parameters:**
 >  (Split by fixed row count) Chunk size (rows) is 1000\\
 \\
-**Output:**
+**Results:**
   * 10 1000-row files with "00000001" through "00000010" appended to the filenames
   * A workflow dataset containing the fully qualified filenames of the split files.
@@ Line 42: / Line 44: @@
 \\ \\
 **Example 2:**  Splitting a comma-delimited text file with 10,000 rows, and splitting by each unique Region value.\\
 \\
-**Action settings:**
+**Action parameters:**
 >  (Split by column value) Separator is Comma
 >  (Split by column value) Column is Region
 \\
-**Output:**
+**Results:**
   *One file for each unique Region value, with the Region values appended to the filenames.
   * A workflow dataset containing the fully qualified filenames of the split files.