Multiple BRD Files - Data360_Analyze - 3 - 3.12

Data360 Analyze Server Help

Product type
Software
Portfolio
Verify
Product family
Data360
Product
Data360 Analyze
Version
3.12
Language
English
Product name
Data360 Analyze
Title
Data360 Analyze Server Help
Copyright
2023
First publish date
2016

This deprecated node combines multiple BRD input files into a single output.

CAUTION:
This node has been deprecated and will not be supported in a future release. As an alternative, the BRD File node can be used to provide similar functionality.

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.