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 2019-02-08 07:42:14 by Anduril 2.0.0