Filter By String Length

This node filters the Rows within the given string length. The column to be used for determining the string length is specified.

Input

It accepts a DataFrame as input from the previous Node

Type

transform

Class

fire.nodes.etl.NodeFilterByStringLength

Fields

Name	Title	Description
inputCol	Input Column Name	input column name
minLength	Minimum length	Minimum length of String
maxLength	Maximum length	Maximum length of String

Details

Filter By String Length Node Details

This node filters Rows for the specified data length range. It helps to define a validation rule on the selected column.

New outgoing Dataframe is created by applying Data Length Range filter on the selected column. Outgoing Dataframe consists of rows where in Data Length of the specified column is within the defined Length Range.

Input

• INPUT COLUMN NAME :- Select a String column on which filter is to be applied.

• MINIMUM LENGTH :- Enter starting value of the Data Length Range Filter.

• MAXIMUM LENGTH :- Enter ending value of the Data Length Range Filter.

Output

• It will filter rows by applying Data Length Range filter using ‘MINIMUM LENGTH’ and ‘MAXIMUM LENGTH’ on the select column.

Examples

Filter By String Length Node Examples

Incoming Dataframe

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

EMP_CD    |    EMP_NAME    |    DEPT    |    SALARY    |    AGE
------------------------------------------------------------------------
E01       |    ANTHONY     |    HR      |    50000     |    40
E02       |    LISA        |    HR      |    50000     |    35
E03       |    MARTIN      |    HR      |    20000     |    25
E04       |    DAVID       |    SALES   |    55000     |    40
E05       |    MARK        |    SALES   |    60000     |    45
E06       |    JOE         |    SALES   |    40000     |    25
E07       |    BELLA       |    HR      |    60000     |    24

FilterByStringLength Node Configuration

FilterByStringLength node is configured as below:

INPUT COLUMN NAME : EMP_NAME

MINIMUM LENGTH : 3

MAXIMUM LENGTH : 5

FilterByStringLength Node Output

Outgoing Dataframe would be created as below and consists of the rows falling within the given string length range:

EMP_CD    |    EMP_NAME    |    DEPT    |    SALARY    |    AGE
------------------------------------------------------------------------
E02       |    LISA        |    HR      |    50000     |    35
E04       |    DAVID       |    SALES   |    55000     |    40
E05       |    MARK        |    SALES   |    60000     |    45
E06       |    JOE         |    SALES   |    40000     |    25
E07       |    BELLA       |    HR      |    60000     |    24