transformations:filesplitter
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revision | Last revisionBoth sides next revision | ||
| transformations:filesplitter [2021/07/19 01:51] – [Examples] craigt | transformations:filesplitter [2021/07/19 02:35] – [Examples] craigt | ||
|---|---|---|---|
| Line 33: | Line 33: | ||
| **Example 1:** Splitting a comma-delimited text file with 10,000 rows, and splitting every 1,000 rows.\\ | **Example 1:** Splitting a comma-delimited text file with 10,000 rows, and splitting every 1,000 rows.\\ | ||
| + | \\ | ||
| **Action parameters: | **Action parameters: | ||
| > (Split by fixed row count) Chunk size (rows) is 1000\\ | > (Split by fixed row count) Chunk size (rows) is 1000\\ | ||
| + | |||
| \\ | \\ | ||
| - | **Output:** | + | **Results:** |
| * 10 1000-row files with " | * 10 1000-row files with " | ||
| * A workflow dataset containing the fully qualified filenames of the split files. | * 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.\\ | **Example 2:** Splitting a comma-delimited text file with 10,000 rows, and splitting by each unique Region value.\\ | ||
| + | |||
| \\ | \\ | ||
| **Action parameters: | **Action parameters: | ||
| > (Split by column value) Separator is Comma | > (Split by column value) Separator is Comma | ||
| > (Split by column value) Column is Region | > (Split by column value) Column is Region | ||
| + | |||
| \\ | \\ | ||
| - | **Output:** | + | **Results:** |
| *One file for each unique Region value, with the Region values appended to the filenames. | *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. | * A workflow dataset containing the fully qualified filenames of the split files. | ||
transformations/filesplitter.txt · Last modified: 2022/12/04 16:34 by dmitry