User Tools

Site Tools


transformations:filesplitter

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
Last revisionBoth sides next revision
transformations:filesplitter [2021/07/19 01:39] craigttransformations: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 settings:**+\\  
 +**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 "00000001" through "00000010" appended to the filenames   * 10 1000-row files with "00000001" through "00000010" 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.
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 settings:**+**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

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki