transformations:filesplitter
Differences
This shows you the differences between two versions of the page.
Next revision | Previous revisionLast revisionBoth sides next revision | ||
transformations:filesplitter [2017/12/23 09:59] – created dmitry | transformations:filesplitter [2021/07/19 02:35] – [Examples] craigt | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== File splitter | + | {{ transformations: |
+ | ======SPLIT DELIMITED FILE ====== | ||
+ | Category: Import / File\\ | ||
- | This transformation | + | \\ |
+ | =====Description===== | ||
+ | This action | ||
- | Since File Splitter | + | \\ |
+ | =====Action settings===== | ||
+ | ^ Setting | ||
+ | |Input file< | ||
+ | |Encoding|ASCII, | ||
+ | |Skip first lines< | ||
+ | |Output folder< | ||
+ | |Output mode|The method by which the input file will be split.\\Options: | ||
+ | < | ||
+ | \\ | ||
+ | ====Output mode settings==== | ||
+ | ^Setting^Description^ | ||
+ | |Split by fixed row count|The input file will be split into a new file every // | ||
+ | |Split by column value|The input file will be split into a new file for every unique value found in the specified column. | ||
+ | < | ||
+ | |||
+ | \\ | ||
+ | =====Remarks===== | ||
+ | Since this action | ||
+ | |||
+ | In addition to splitting the input file, this action outputs a single-column dataset containing a list of the split files' filenames.\\ | ||
+ | |||
+ | \\ | ||
+ | =====Examples===== | ||
+ | **Example 1:** Splitting a comma-delimited text file with 10,000 rows, and splitting every 1,000 rows.\\ | ||
+ | |||
+ | \\ | ||
+ | **Action parameters: | ||
+ | > (Split by fixed row count) Chunk size (rows) is 1000\\ | ||
+ | |||
+ | \\ | ||
+ | **Results: | ||
+ | * 10 1000-row files with " | ||
+ | * A workflow dataset containing the fully qualified filenames of the split files. | ||
+ | |||
+ | \\ \\ | ||
+ | **Example 2:** Splitting a comma-delimited text file with 10,000 rows, and splitting by each unique Region value.\\ | ||
+ | |||
+ | \\ | ||
+ | **Action parameters: | ||
+ | > (Split by column value) Separator is Comma | ||
+ | > (Split by column value) Column is Region | ||
+ | |||
+ | \\ | ||
+ | **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. | ||
+ | |||
+ | |||
+ | \\ | ||
+ | =====See also===== | ||
+ | |||
+ | * [[transformations: | ||
- | File Splitter is not available in the free edition. |
transformations/filesplitter.txt · Last modified: 2022/12/04 16:34 by dmitry