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 --------- .. list-table:: :widths: 10 5 10 :header-rows: 1 * - 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