Update multiple column values in Data table

Help Activities
1

Is there any activity which adds values of multiple columns inside for each row in data table activity?

I dont want to use multiple update row item activities to update multiple column values.

2

Hey @Sonalk,

Have a look on this to update the multiple columns.

Thanks,
Sanjit

3

Hi @Sonalk ,I hope you are doing well.
How about the follwing using InvokeCode activity?
dt.AsEnumerable.Where(Function(r) r(ā€œinput column nameā€).ToString =ā€œcolumn valueā€).ToList.ForEach(
Sub(r)
r(ā€œinput column nameā€)=r(ā€œtarget column nameā€).ToString
End Sub
)

Thanks & Regards,
Shubham Dutta

4

Hi @Sonalk

Have a look on the docs

Hope it will helps

Regards
Gokul

2 Likes
5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.