How to sum value in cell?

Help Studio
,
#1

Hello!

I have DataTableRow in this format: USA, New York, Mark, 100USD

And I need to add it to another DT, but I have to check if country(row(0)), city(row(2)), name(row(3)) match up, then I need to plus the amount and not create a new line.

Please give me advice how to do it.

#2

Hai @Olek1… Initially store Excel and get output as dt … Then use if condition like u mentioned if condition matches then sum the rows refer it
BalaReva.DataTable.Activities - #2 by balupad14…

1 Like
#3

Nandhura Hello!
I have problem in this example…Can you help me please…

image
image1920×1080 192 KB

1 Like
#4

@Olek1… Go to manage packages… And update or reinstall the Excel activities

1 Like
#5

Thanks for your help) Tell me please, Can I use it without Excel, only in DT?

1 Like
#6

Hi @Olek1,

Go to manage and package and follow steps…

image
image1118×580 118 KB

and

image
image1118×862 357 KB

It will fix the problem…

Thank you
Balamurugan.S

1 Like