String Functions

String Functions Multiple

Type

transform

Class

fire.nodes.etl.NodeStringFunctionsMultiple

Fields

Name	Title	Description
inputCols	Columns	Columns
functions	Function	String Function to apply
replaceExistingCols	Replace Existing Cols	Whether to replace the existing columns or create new ones

Details

String Functions Multiple Node Details

This node creates a new Dataframe by transforming data of multiple columns using specified string functions. Multiple columns can be selected for transformations. Only one String Function can be selected for each transformation.

It applies String Function to on Columns to generate a new evaluated column.

Choose whether you want to replace(true) the existing column or create a new column(false) by choosing the value for the field replaceExistingCols .

Then the output dataframe will be created with the new column.

One can choose a column from the dropdown in the field inputCols, and then choose one of the function (trim, upper, lower, lefttrim, righttrim, removewhitespace) to apply to the column chosen.

Column data would be transformed as below based on the function selected:

Trim

It removes leading and trailing blank spaces from values in the selected columns. -> Example: ‘ Remove Spaces ‘ would be changed to ‘Remove Spaces’

Lower

It changes case of the selected columns to lower in the output. -> Example: ‘Change Case’ would be changed to ‘change case’

Upper

It changes case of the selected columns to upper in the output. -> Example: ‘Change Case’ would be changed to ‘CHANGE CASE’

LeftTrim

It removes leading blank spaces from values in the selected columns. -> Example: ‘ Remove Spaces ‘ would be changed to ‘Remove Spaces ‘

RightTrim

It removes trailing blank spaces from values in the selected columns. -> Example: ‘ Remove Spaces ‘ would be changed to ‘ Remove Spaces’

RemoveWhiteSpaces

It removes all blank spaces from values in the selected columns. -> Example: ‘ Remove Spaces ‘ would be changed to ‘RemoveSpaces’

Examples

String Functions Multiple Node Examples

Incoming Dataframe

In this example we have considered a Incoming Dataframe with following rows:

EMP_CD    |    EMP_NAME    |    DEPT
-------------------------------------------------------
E01       |    DAVID       |    HUMAN RESOURCE
E02       |    JOHN        |    PRODUCT SALES
E03       |    MARK        |    MARKETING MANAGEMENT

String Functions Multiple Node Configuration

StringFunctionsMultiple node is configured as below to perform following transformations:

COLUMNS        |    FUNCTION          |      REPLACE EXISTING COLS
--------------------------------------------------------------------
EMP_NAME       |    lower             |      false
DEPT           |    removewhitespace  |      false

String Functions Multiple Node Output

Outgoing Dataframe would be created as below after applying above transformations:

EMP_CD    |    EMP_NAME    |    DEPT                   |    EMP_NAME_lower    |    DEPT_removewhitespace
-----------------------------------------------------------------------------------------------------------
E01       |    DAVID       |    HUMAN RESOURCE         |    david             |    HUMANRESOURCE
E02       |    JOHN        |    PRODUCT SALES          |    john              |    PRODUCTSALES
E03       |    MARK        |    MARKETING MANAGEMENT   |    mark              |    MARKETINGMANAGEMENT

Multiple transformations can be performed on a column; however, only the last transformation can have [REPLACE EXISTING COLS] option set as [true]