Hello, all you have to do is read column 2 into separate data tables …for dt2 containing all the amounts you sum them while looping through and then you compare the values .
Hold on I am doing a sample workflow for you right now
For the Sheet 2 - In the Excel File itself - Can we have a Formula at the Bottom which sums up the Submitted Amount for us in Excel. If yes- let say you have the Sum available in Cell A20 - we Read this sheet directly by read cell and get the Total .
Next we Go to the Sheet 1 and assuming the Total in sheet 1 is at fixed cell B20 - we Read this cell and get the Total.
Hi Mukeshkala,
Thanks for the reply.
Unfortunately I can’t use the formula on the excel sheet.
It would have been nice, but not applicable to my situation.
I have to do the processing using the datatable and excel Workbook.
I will need the output to determine one or the other operation.
Hi David,
To be honest, it doesn’t work.
I don’t know the commands you have set.
I am very inexperienced with UiPath …but, your flow,
says the total doesn’t match,
while, making the sum, however, the total is the same.
Hello Aaron, please find attached. i have have configured the sequnce with the same excel you sent.let me know if its okay. CompareAmount_New.zip (23.1 KB)
1.Create two data table variables DT1 and DT2.
2.Use for each row pass DT1 and then use another for each row activity pass DT2.
3.Use If condition compare row(“DT1ColumnName”).contais(row(“DT2ColumnName”)).
What you did, I think is what comes closest to my need.
the check is correct, but I should extend it.
First problem is that the original file contains other columns, so it gives me an error in the flow.
This is my worksheet. 10905-ExCoupa.xlsx (11,8 KB)
Basically, after a series of scraping,
obtaining two tables “Coupa” and “Snow” that I have to compare in the exposed totals.
The consideration is that a Purchase Order can consist of one or more lines on Service Now,
and on Coupa, the same. The order can be placed in one line or multiple lines for the same purchase order.
What you did, I think, do this check, considering the columns Purchase_Order and Submitted Amt.
Is it possible to external considering also the Po Line, ignoring the other columns present?
Or have an output on a new sheet, the lines joined together.
After that, I would be autonomous in subsequent operations.