Subtraction of the two columns

Help Activities
, ,
1

Hi All,
Good afternoon.
Can anyone help me to do the subtraction operation in uipath.
i.e I wanna subtract two different column in a excel and write the result in another column.
Column3= Column1-Column2.

I am trying like this:

  1. Reading excel file(DT1).
  2. Passed the DT1 in for each loop.
  3. Get row item(Column1)
  4. Get row item(Column2)
  5. In an assign activity I am displaying the output like Column3= Column1-Column2
    but I am getting an error like in the attachment.
    Please someone help me on this

Best Regards,
Naveen S

Screenshot (61)
Screenshot (61)1366Ă—768 82.3 KB

And my workflow looks like:
Screenshot (62)
Screenshot (62)1366Ă—768 78.1 KB

2

Hi @HeartCatcher

Try like method below.

  1. Reading excel file(DT1).
  2. Passed the DT1 in for each loop.
  3. Inside the loop assign
    Currentrow(“Result”)=Cint(currentrow(“Credit”).tostring)-Cint(Currentrow(“Debit”).toString)
    4.Outside the loop write range Dt1.

Regards

3

Hi @pravin_calvin,
Thanks for the reply, I tried as you suggested but I am getting an error as in the attachment

Screenshot (64)
Screenshot (64)1366Ă—768 86.1 KB

4

Add a condition that if that cell is empty it wont do this activity

5

Hi @Gresilda_Balla,
Thanks for the response I tried I am getting error like

Screenshot (65)
Screenshot (65)1366Ă—768 81.1 KB

Please help me out on the same

6

we can defensive handling empty cell value with following:
Cint(“0” & currentrow(ColNameOrIndex).tostring)

1 Like
7

Sorry didn’t get you

8

please show us the implementation from this: Column3= Column1-Column2

9

Credit-Debit.xaml (18.3 KB)
please find

10

Screenshot (67)
Screenshot (67)1366Ă—768 84.2 KB

11

there are severeal things to check and maybe to adopt

crosscheck if name or index is properly used for referencing the column
after opening the xaml we saw:
grafik
(maybe an opening issue on quick review)
and do see following when click on Name
grafik

give a try on Cint(“0” & Credit.toString) - Cint(“0” & Debit.toString)

In general:

  • using assign activity for getting row’s col value like below allows us to get more control on what we get as the variable type is set by us and the retrieval statement is done by us:
    grafik

Just start with these modifications and lets see what you will get on next run

So adopt it if needed

12

@ppr,

As you said I have checked the index in get row item its correct.
after that what you said I didn’t can you please explain a bit

13

run it check please

14

Screenshot (68)
Screenshot (68)1366Ă—768 85.7 KB

15

Cint(“0” & Credit.toString) - Cint(“0” & Debit.toString)

16

Screenshot (69)
Screenshot (69)1366Ă—768 82.4 KB

I tried your method but I am getting the error

17

Credit-Debit.xlsx (14.7 KB)
Please find the excel which I am using to achieve the subtraction.

18

0-3790 string is not value that can be converted into an int. So your data quality is not on a state that the impementation can run or there is a bug in the implementation that creates this string

we can convert 1,2,3 …100 but not number-number …

Issue occured on this part: Cint(“0” & Credit.toString) - Cint(“0” & Debit.toString), right?

Check the statement on your implementation again

19

you have to convert that value into integer use Cint function

20

@HeartCatcher
Defensive 0 Trick was confused by negative values

Variables:

grafik
grafik820Ă—219 36.1 KB

MainFlow:

grafik
grafik688Ă—658 42.3 KB

Credit = CurrentRow(“LCY_AMOUNT”).toString
iCredit = if(isNothing(Credit) OrElse String.IsNullOrEmpty(Credit.ToString), 0, CInt(Credit))

Find some starter help here:
Credit-Debit.xaml (12.6 KB)

1 Like