extractor_input_csv_column

Maps input columns to output columns

Primary Key:

• extractor_input_id
• extractor_output_reference_id
• extractor_column_id

Foreign Keys:

• extractor_column_id => extractor_column.extractor_column_id
• extractor_input_id => extractor_input.extractor_input_id
• extractor_output_reference_id => extractor_output_reference.extractor_output_reference_id

Indexes:

• extractor_input_csv_column_extractor_column_id_idx - extractor_column_id
• extractor_input_csv_column_extractor_output_reference_id_idx - extractor_output_reference_id

Column	Data Type	Nullable	Indexed	Description
extractor_input_id	bigint	No	Yes	The extractor input the column mapping belongs to Generated through expression:
extractor_column_id	bigint	No	Yes	The output column the input CSV column is mapped to Generated through expression:
column_regex	text	No	No	A regex used to help identify the column in the CSV which contains the desired data. Note that a regex is used since the format of a particular CSV may change slightly over time. Generated through expression:
extractor_output_reference_id	bigint	No	Yes	The related output reference Generated through expression:
optional	boolean	No	No	Whether this column mapping is optional. If true and the input column is missing from the source file, the column will be treated as empty rather than causing an error. Generated through expression:
use_first_match	boolean	No	No	Whether to use the first matching column when the regex matches multiple headers. If this option is not set and the regex matches multiple headers, extractor will error by default. Generated through expression: