Add Columns

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.NodeAddColumns

Fields

Name

Title

Description

addCurrentDateCol

Add Current Date Column

Whether to add the current date as a new column

currentDateColName

Current Date Column Name

Name of the new Current Date Column Created

addCurrentTimeCol

Add Current Time Column

Whether to add the current time as a new column

currentTimeColName

Current Time Column Name

Name of the new Current Time Column Created

addConstantStringCol1

Add Constant String Column

Whether to add a new columns with constant string value

constantStringColName1

Constant String Column Name

Constant String Name

constantStringColValue1

Constant String Column Value

Constant String Value

addConstantIntCol1

Add Constant Integer Column

Whether to add a new columns with constant integer value

constantIntColName1

Constant Integer Column Name

Constant Integer Column Name

constantIntColValue1

Constant Integer Column Value

Constant Integer Value

addConstantDoubleCol1

Add Constant Double Column

Whether to add a new columns with constant double value

constantDoubleColName1

Constant Double Column Name

Constant Double Column Name

constantDoubleColValue1

Constant Double Column Value

Constant Double Value

Details

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

New columns can be created for Current Date value, Current Datetime value, a Constant String value or a Constant Integer value.

Names for new columns along with values can be provided.

Examples

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

  • CURRENT DATE (Column Name CURRENT_DATE)

  • CURRENT TIME (Column Name CURRENT_TIME)

  • 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