How to add data in new data column?

Help Something Else
1

Hi All,

I have data table with 3 columns … want to Concatenate of column 1 and column2 in column3

image
image775×552 18.2 KB

image
image1189×565 25.4 KB

2

Hi @Mandava_Naresh
Do u want to add a new column of sum SNO & Adm, or the Sum already exists previously?
If it was previously exists, then u just need to use Assign Activity and set row(“Sum”), with value Int32.Parse(row(“SNO”)) + Int32.Parse(row(“Adm”)).

3

Hey!

Try this:

In add data row

in the array of row mention like this:

{SNO,ADM,Concat}

Regards,
NaNi

4

Have to add only one row … First two should remain same

5

hi @Mandava_Naresh ,

Try using Add data column activity, instead of Add data row activity.

6

Yes

Above expression will works the same

Try it and let me know

Regards,
NaNi

7

Sum Column already exists … We just want to add column1+column2 in Sum

8

then u can try my way. Do it in for each row.

9

@Dharunya_Devi

image
image1228×540 32.5 KB

10

@Felix_Effendi I was unable to add sum values in the data table

11

Hi @Mandava_Naresh

What you can do is

  1. Loop through each row of datatable using for each row,

  2. use an assign activity

row(“Sum”)= Cint(row(“SNO”).ToString)+Cint(row(“Adm”).ToString)

You will get the reqd results

Thanks & Regards,
Nived N

13

This one will show u the result in excel file.
Testing Project.zip (1.7 MB)

14

When the Sum of col1 and col2 is needed and you can control the datatype from the columns (as you have used Build Datatable you can change it to Int32) then you can do following

  • ensure thre columns are set to DataType: Int32
    Assign Activity
    YourDataTableVar.Columns(“Sum”).Expression = “[SNO] + [Adm]”

This will compute the sum and will do it without the need of a for each and will also be updated when values in other columns are changed

15

@NIVED_NAMBIAR … I was unable to add row(“sum”) value to data table

16

@ ppr … I was unable to add sum value in data table

17

@Felix_Effendi I want to write result in data table for string … Like how you did in excel for int

18

What error is it throwing?

19

@NIVED_NAMBIAR @Felix_Effendi

image

image
image1240×741 34.8 KB

20

Hi @Mandava_Naresh , btw why the column name change to Concat?
Actually if it previosly has Sum column with String Type in datatable, then u just need to do “For Each Row” then use Assign Activity to assign row(“Sum”) with value (CInt(SNO) + CInt(ADM)).ToString.
No need to use Add Data Row activity anymore.

1 Like
21

Add Data Row activity adds a new row to the datatable. Since you are trying to update the value in a column, change your 3rd Assign activity in For Each Row to row(“Concat”) = SNO + ADM . This will update the Concat column value for that row.

1 Like