Up: Component summary Component

CSV2SetList

Extracts identifier columns from the given CSV files and prints them out without duplicates. This component can be used to create a SetList by combining various sets of identifiers into separate lists.

Version 1.1
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
table1 CSV Optional Input relation 1
table2 CSV Optional Input relation 2
table3 CSV Optional Input relation 3
table4 CSV Optional Input relation 4
table5 CSV Optional Input relation 5
table6 CSV Optional Input relation 6
table7 CSV Optional Input relation 7
table8 CSV Optional Input relation 8
table9 CSV Optional Input relation 9
tables Array<CSV> Optional An array of input relations

Outputs

Name Type Description
lists SetList A collection of lists of selected IDs

Parameters

Name Type Default Description
cols string "" A comma separated list of column names for the input tables and the ID selection (table1=idcolumn). Array keys are used as table names for the tables input. The default column is the first one.
lists string "" A comma separated list of identifier definitions for the input tables (table1=mylist). Array keys are used as table names for the tables input. The default list name is the name of the input port.

Test cases

Test case Parameters IN
table1
IN
table2
IN
table3
IN
table4
IN
table5
IN
table6
IN
table7
IN
table8
IN
table9
IN
tables
OUT
lists
case1 (missing) table1 table2 (missing) (missing) (missing) (missing) (missing) (missing) (missing) (missing) lists
case2 properties table1 table2 (missing) (missing) (missing) (missing) (missing) (missing) (missing) (missing) lists

lists=table2=list2,
cols=table2=id2

case3 (missing) (missing) (missing) (missing) (missing) (missing) (missing) (missing) (missing) (missing) tables lists

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