Adding multiple column values into single column

[laknar]

i have below input

Col1 Col1A Col1B Col1C

ABC 10 10 10

CDE 10 10 10

EFG 10 10 10

Need output like below

Col1 Col1A Col1B Col1C Col1_SUM

ABC 10 10 10 30

CDE 10 60 10 80

EFG 10 20 10 40

[priyadarshikunal]

you forgot about '+' operator

[agpt]

use transformer

[laknar]

need to add dynamically

additional columns may be added in future.

Col1 Col1A Col1B Col1C Col1D Col1E

[anbu]

Unix solution:

Code: Select all

awk ' { for (i=2;i<=NF;++i){sum+=$i} $NF=$NF FS sum } 1 ' file

[ray.wurlod]

need to add dynamically

additional columns may be added in future.

Col1 Col1A Col1B Col1C Col1D Col1E

You chose not to mention that when posing the original question.

There is a delightfully elegant solution using a server job or a BASIC Transformer stage, where you treat all of the numeric fields as a dynamic array and apply a Sum() or Summation() function thereto.

[laknar]

is there any possibility using Modify stage.
But the columns should not be hard coded.
suppose if i want to sum 100 columns(existing columns) and introduce a new column for the output value.

how can i do this in Schema file and RCP scenario.

[ray.wurlod]

is there any possibility using Modify stage.

No.