HOW TO COMPARE THESE EXCEL FILES?

Help Activities
1

Hello
I need help please help :slight_smile:
I want to compare an excel sheet with incoming orders and an excel sheet showing warehouse stocks with UiPath. What I need is to make calculations between order and stock by matching according to the code sections. To print the order and stock differences of the matched products on a new excel sheet. This is everything …
Please help me .

Forum 1
Forum 1898Ă—674 121 KB

2

@Ertugrul_Dagci
Welcome to the forum

Have a look here

and have a look at the Join DataTable Activity

3

Hello Ertugrul, you can use join data table activity. After joining the data tables from the two sheets you can filter the redundant columns using “Filter Data Table” activity and add a new data column using “Add Data Column” activity for the stock and order differences.

4

@Ertugrul_Dagci

Welcome to the community

Join datatable activity will help in getting thw matched values between the two tables

Then use below in assign to get the difference,before that make sure to add the column to write the difference in

Dt.Columns("Difference").Expression = "[Order] - [Stock]"

Cheers

5

Hi @Ertugrul_Dagci
Input:

image
image468Ă—784 8.45 KB

image
image438Ă—776 8.84 KB

Refer the below workflow for better understanding:

image
image880Ă—1198 62.8 KB

Sequence3.xaml (10.0 KB)

Output:

image
image635Ă—751 9.68 KB

Hope it helps!!
Regards

6

Thank you very much :slight_smile:

1 Like
7

If you find solution for your query please mark it as solution to close the loop.

Happy Automation

Regards

8

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