Modify Field Prefix - Data360_Analyze - 3.12

Data360 Analyze Server Help

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

Adds or removes a prefix to all input field names in the data.

If you are joining multiple data sources, you may want to add a prefix to help you to identify the data source or to avoid conflicting field definitions when joining data sets that contain identical field names.

To configure this node:

  1. In the Prefix property, enter the prefix that you want to add or remove.
  2. To add the prefix, set the Add property to True (this is the default).

    To remove the prefix, set the Add property to False.

  3. If you want to add the prefix to input field names that already start with the specified prefix, set the Force property to True (in this case, the Add property must also be set to True).

Example

Adding a prefix

You have the following input data:

Product_Codeunicode Productunicode
15 Tea
2 Coffee
3 Water
15 Tea
15 Tea

In the Prefix property, type:

PREFIX_

If the Add property is set to true and the Force property is set to default, the specified prefix is added to both input field names as follows:

PREFIX_Product_Codeunicode PREFIX_Productunicode
15 Tea
2 Coffee
3 Water
15 Tea
15 Tea

Prefix is already used in one of the input field names

You have the following input data:

Product_Codeunicode PREFIX_Productunicode
15 Tea
2 Coffee
3 Water
15 Tea
15 Tea

In the Prefix property, type:

PREFIX_

If the Add property is set to true and the Force property is set to default, the prefix is added to both column names, regardless of whether the input name already starts with the same prefix, as follows:

Product_Codeunicode PREFIX_PREFIX_Productunicode
15 Tea
2 Coffee
3 Water
15 Tea
15 Tea

Removing a prefix

You have the following input data:

Product_Codeunicode PREFIX_Productunicode
15 Tea
2 Coffee
3 Water
15 Tea
15 Tea

In the Prefix property, type:

PREFIX_

If the Add property is set to false and the Force property is set to default, the prefix is removed from the Product column, as follows:

Product_Codeunicode Productunicode
15 Tea
2 Coffee
3 Water
15 Tea
15 Tea

Properties

Prefix

Specify the prefix that you want to add or remove.

A value is required for this property.

Add

Optionally specify whether to add the specified prefix to the input field names. If set to false, the specified prefix is removed from the input field names.

The default value is True.

Force

Optionally specify whether to add the specified prefix to the input field names even if the field already starts with the prefix (if the Add property is also set to true).

The default value is False.

Inputs and outputs

Inputs: in1.

Outputs: out1.