Static column/row data addition

Question

I am trying to modify a 100-row excel input file by adding a new header, "PGM TYPE" and hard code "0001" in every row in this new column. I know you can use the generate rows tool to add a column to an input file but I'm having challenges adding the "0001" value for each row. Any feedback is appreciated - thanks!

Emmanuel_G · Answer

Hi @Grape ,

You don't need to use Generate Rows tool. When you use the formula tool. The expression inside is applied to all the rows of your dataset as shown below in screenshoots.

Amol_Telore · Answer

Hi @Grape

It is my understanding that you are trying to add a new column in data and value of this new column will be '0001' for all the 100 records.

To do this you can use formula tool.

* In column names, instead of selecting existing columns select add a new column and enter column name as 'PGM TYPE'
* In the expression editor window, enter '0001'. Keep data type as String. If selected as Numeric data type then it will remove starting zeroes.
* It will show 0001 value for all 100 records now.

Robin_McIntosh · Answer

Just use a simple formula tool.