Up: Component summary Component

CSVListJoin

Combines 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,
fileCol =

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


Generated 2018-12-11 07:42:06 by Anduril 2.0.0