I have data table with 3 columns … want to Concatenate of column 1 and column2 in column3
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”)).
In add data row
in the array of row mention like this:
Have to add only one row … First two should remain same
hi @Mandava_Naresh ,
Try using Add data column activity, instead of Add data row activity.
Above expression will works the same
Try it and let me know
Sum Column already exists … We just want to add column1+column2 in Sum
then u can try my way. Do it in for each row.
@Felix_Effendi I was unable to add sum values in the data table
What you can do is
Loop through each row of datatable using for each row,
use an assign activity
You will get the reqd results
Thanks & Regards,
This one will show u the result in excel file.
Testing Project.zip (1.7 MB)
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
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
@NIVED_NAMBIAR … I was unable to add row(“sum”) value to data table
@ ppr … I was unable to add sum value in data table
@Felix_Effendi I want to write result in data table for string … Like how you did in excel for int
What error is it throwing?
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.
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.