Add Column Advanced

This node allows adding new columns with certain values

Input

This type of node takes in a DataFrame and transforms it to another DataFrame

Output

This node adds the user specified columns to the DataFrame

Type

transform

Class

fire.nodes.etl.NodeAddConstantColumn

Fields

Name

Title

Description

constantTypes

Constant Type

Constant Types

outputCols

Output Column

New Output column name.

constantValues

Constant Value

ConstantValues when type is ConstantString and ConstantInt.

Details

It creates a new DataFrame by adding new columns to the input Dataframe.

New columns can be created for selected types from dropdown in Constant Types field.

In Output Columns field provide the name of new columns.

In Constant Values field provide the respective constant value when type is ConstantString or ConstantInt.

When type is CurrentDate or CurrentTimeStamp, leave the Constant Values field should be left empty - currentdate and currentimestamp values will be get populated automatically.

This node supports the multiple add columns - Multiple constant type columns can be added.

Examples

If option for adding new columns is selected as below with new column names specified in bracket

  • CurrentDate (Column Name CurrentDate)

  • CurrentTimeStamp (Column Name CurrentTimeStamp)

  • STRING Column with a value DrillMachine (Column Name MACHINE_NAME)

  • INTEGER column with a value 100 (Column Name MACHINE_WEIGHT)

then following columns would be added to the output Dataframe with mentioned values:

  • CURRENT_DATE : 2021-10-22

  • CURRENT_TIME : 2021-10-22 04:34:00.532

  • MACHINE_NAME : DrillMachine

  • MACHINE_WEIGHT : 100