This deprecated node combines multiple BRD input files into a single output.
This node, for each row, opens a file as specified by the Filename property and outputs the contents of the file. If the input files have different headers, the ConcatenationMode and TypeConversion properties describe how to handle the differences.
Properties
Filename
Specify which data to use for the filename.
A value is required for this property.
ConcatenationMode
Optionally specify how to merge data. Choose from:
- Union - Outputs all of the fields across the inputs, filling in nulls for fields not present in a given input.
- Exact - The fields for all inputs must be the same.
- Intersection - Outputs all the fields common to the inputs.
The default value is Exact.
FilenameOutputField
Optionally specify a field to record the originating filenames into.
TypeConversion
Optionally specify how to handle columns that have the same name, but different types. Choose from:
- None - No type conversion, all fields have to match exactly.
- Numeric - Numerical conversions will occur, int to longint to double precision float.
- Unrestricted - Numerical conversions will occur - additionally, incompatible types will be converted to string if possible.
The default value is Numeric.
Inputs and outputs
Inputs: in1.
Outputs: BRD Data.