Up: Component summary
Up: Component summary
Component
CSVListJoinCombines the content of input files into a single CSV file. The columns of the output file will form a union of all column names of the input files plus an additional column for the names of the source files.
Conflicting file names in output are replaced with names with a suffix like _i where i is an interger starting from 2 and running to the first unused file name.
See CSVJoin without keys for an alternative row joining method.
| Version | 3.2 |
|---|---|
| Bundle | tools |
| Categories | Convert |
| Authors | Marko Laakso (Marko.Laakso@Helsinki.FI) |
| Issue tracker | View/Report issues |
| Source files | component.xml |
| Usage | Example with default values |
Inputs| Name | Type | Mandatory | Description |
|---|---|---|---|
| folder | CSVList | Optional | A folder of input CSVs |
| in | Array<CSV> | Optional | A list of CSVs |
| in1 | CSV | Optional | An optional input file |
| in2 | CSV | Optional | An optional input file |
| in3 | CSV | Optional | An optional input file |
| in4 | CSV | Optional | An optional input file |
Outputs| Name | Type | Description |
|---|---|---|
| out | CSV | Joint content of the input files |
Parameters| Name | Type | Default | Description |
|---|---|---|---|
| acceptExt | string | "" | File extension that selects the files of interest. Add a dot (like .csv or .motif) into this parameter if the extension has it. Empty value refers to all files. |
| fileCol | string | "file" | Column name for the source file names. The whole column will be omitted if this string is empty. |
| stripExt | boolean | true | This flag can be used to remove file extensions from the source file names. |
| useKeys | boolean | true | Use array keys as output file names |
Test cases| Test case | Parameters▼ | IN folder |
IN in |
IN in1 |
IN in2 |
IN in3 |
IN in4 |
OUT out |
|---|---|---|---|---|---|---|---|---|
| case1 | properties | folder | (missing) | (missing) | (missing) | (missing) | in4 | out |
|
acceptExt=.csv |
||||||||
| case2 | (missing) | (missing) | (missing) | (missing) | (missing) | (missing) | (missing) | out |
| case3 | properties | folder | (missing) | (missing) | (missing) | (missing) | in4 | out |
|
acceptExt=.csv, |
||||||||
| case4 | properties | (missing) | in | (missing) | (missing) | (missing) | in4 | out |
|
useKeys = false |
||||||||
| case5 | (missing) | (missing) | in | (missing) | (missing) | (missing) | in4 | out |
| case6_fileCol_exists | properties | (missing) | (missing) | in1 | (missing) | (missing) | in4 | (expecting failure) |
|
fileCol=f1Col1 |
||||||||