How to calculate the value of a column in excel by uipathX?

Help Activities
, ,
1

For example Data:

image
image793×323 15 KB

because the data of the 2 excel files are the results of 2 data joins

For my activity:
JoinDataTable.zip (188.0 KB)

2

@bayu.herlambang

You want the difference between amount and amount1?

If so first if columnis not present use add data column and add difference column and then use assign activity as below

dt.Columns("Difference").Expression = "[Amount]-[Amount1]"

Cheers

1 Like
3

Thank Anil,
Can you show me an example through the activity tools in UiPath?

:smile:

4

@bayu.herlambang

It is just one activity…set to variable

Cheers