Pivot - Names To Data - 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

Converts the field names in the metadata of an input data set into field values in output records.

For each input record, a new output record will be constructed for each of the fields referenced in the PivotFields property. The name of the pivot field will be placed in the NamesOutputField field, and the value of that field on the output record will be placed in the DataOutputField field. All of the other fields on the output record are the same as the values on the input record.

Properties

PivotFields

Specify the fields over which to pivot. This property can accept the wildcards "*" and "?". These field names or field patterns are presented in a comma-separated, case-preserving list.

A value is required for this property.

DataOutputField

Optionally specify the case-preserving name of the output field that contains the data from the pivot fields. The output field's type matches that of the fields in PivotFields unless TypeConversion property is not set to None.

The default value is "Data".

NameOutputField

Optionally specify the case-preserving name of the field that contains the name of the fields from which this particular point has come.

The default value is "Names".

TypeConversion

Optionally specify how the data in the PivotFields are to be output. Choose from:

  • To Unicode - Converts all data in the fields identified by PivotFields to Unicode during the course of the Pivot.
  • To String- Converts all data to strings.
  • None - The types of all the PivotFields must match, or this node will fail.

The default value is None.

OutputNullCells

Optionally specify if an output row is produced if its DataOutputField data is NULL. If this property is set to true, then the row is output. If this property is set to false, then the row is suppressed. When this property is false, this operation can only be reversed using the "Pivot - Data To Names" node if the original input data did not contain any NULL cells in the data field.

The default value is True.

Inputs and outputs

Inputs: in1, multiple optional.

Outputs:pivotTable, multiple optional.