Reorder Fields - 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

Selects and reorders fields.

The Field Order property lists all available input fields on the node. You can reorder the fields and select fields to include in the output.

If there is no input data on the Reorder Fields node, you can type the name of a field in the Ordered Fields grid. When the node receives input data, any fields that do not exist will be highlighted in orange.

Reordering fields

Select the field(s) that you want to reorder and use the buttons on the right to change the order. Choose from:

  • Move to Top
  • Move Up
  • Move Down
  • Move to Bottom

All selected fields will be moved. For example, you have the following fields:

A

B

C

D

E

F

If you select fields C and E and click the Move Up button, the field order would become:

A

C

E

B

D

F

Tip: You can reset the list of ordered fields to match the input by clicking Reset. If there are any new input fields, these will also be added to the list.

Keyboard shortcuts

When the Field Order property is selected, you can use the following keyboard shortcuts:

Keyboard shortcut Description
Ctrl + click to select fields Select multiple fields
Shift + click to select fields Select a range of fields
Ctrl + A Select all
Delete or Backspace Remove field(s)

Finding fields

If you are working with a large number of fields, you can type to search for a specific field. Use the arrows to the right of the search box to navigate through the matches.

Excluding fields

You can exclude one or more fields from the output by selecting the fields that you want to remove and clicking the Remove Fields button.

Adding fields

Only the fields that are listed in the Field Order property will be included in the output.

You can restore fields that have previously been excluded, or add new fields that have been added to the input data set:

  1. Click the Add Fields button.
  2. The Add Fields dialog lists all available fields on the left, and selected fields on the right. Use the left and right arrows to add or remove fields.
  3. You can also reorder selected fields from this dialog by using the Move to Top, Move Up, Move Down and Move to Bottom buttons.
  4. Click Done to save your changes.
Note: Setting the FieldsNotExistsBehavior property to Ignore (or Log) can be useful if your input data can contain optional fields and you want to specify the order of the fields when they are present, but avoid generating an error when they are absent.

Properties

Field Order

Populate the table with a list of fields which specify the order in which input fields will be written in the output.

Select fields to add or remove from the output. Any fields that are not specified in the list will be excluded from the output.

FieldsNotExistBehavior

Optionally specify the node behavior when there are fields specified in the Field Order property that do not exist on the incoming data set. Choose from:

  • Error - The node will error when it finds fields listed in the Field Order property that do not exist on the incoming data set. The erroneous fields will be listed in the error detail.
  • Log - A warning will be logged by the node when it finds fields listed in the Field Order property that do not exist on the incoming data set. The erroneous fields will be listed in the warning detail.
  • Ignore - No warning will be logged by the node. Any fields found in the Field Order property that do not exist on the incoming data set will be ignored.

The default value is Error.

Example data flows

A number of sample Data Flows are available from the Samples workspace, found in the Analyze Directory page.

In the Directory under the /Data360 Samples/Node Examples/ folder, you will find "Re-ordering fields", which shows examples of how to use this node.

Note: Upgrades will overwrite all data flows in the workspace. If you want to make changes to one of the sample data flows, we recommend you create a copy and save it elsewhere, using Save as...

Inputs and outputs

Inputs: in1

Outputs: reorderedData