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