Respected Sir/ Ma’am,
I hope this message finds you well. I am currently working on a UiPath workflow and encountering some issues that I could use some help with. Here’s a brief overview of my requirements:
–Data Comparison
I have an Excel file with two sheets: “Customers” and “OBSL.”
- In the “Customers” sheet, there’s a column named “BP Code.”
- In the “OBSL” sheet, you’ll find a column called “SL1Code.”
–Here’s what I want to achieve:**
a. Compare the values in the “BP Code” column (from “Customers”) to the entire “SL1Code” column (in “OBSL”).
b. When a match is found, I want to copy the entire corresponding row from the “Customers” sheet to another sheet called “Duplicate.”
c. If there’s no match, I need to copy the row to a sheet called “CUST_FINAL.”
I’ve made attempts to implement this in UiPath using the “For Each Row” loop and various activities, but I’m encountering errors, and I’m uncertain about where I’m making mistakes.
I’ve attached a .zip file that contains my UiPath workflow and the Excel file for your reference. Could you please review it and provide guidance on how to accomplish this?
Thank YOU
EXL_upDATE_2.zip (72.8 KB)
Hi @badal_patel ,
Compare 2 data table is simple in rpa, I will try your files
regards,
Hi @badal_patel ,
I see your data
I need you confirm that is you need compare sheet Customers with sheet OBSI,
I see them are not match BPcode and SL1Code
I think you need compare BPName with SL1Code
pls confirm
yes each BP Name with full SL1Code
OK, we have case match
thanks
Sheet2, we don’t care it
that’s right?
yes, sheet 2 not used anywhere
Hi
You can check
my input/output
and my code
Hana.zip (138.6 KB)
regards,
for Duplicate is not working, please check again
I clear all to check
then output in Duplicate
can you test again and check any case duplicate?
yes but
FOR TESTING I ENTER SAME NAME IN CUSTOMERS AND OBSL THEN I RUN FLOW BUT I CAN SEE ONLY ONE RAW IN DUPLICATE
SO PLEASE CHECK
ok I see
you can try
DataCompare.zip (144.3 KB)
but I will test again with LINQ to faster.
GEETING ERROR THIS PLEASE CHECK AND LET ME KNOW
Hello Sir,
Please check and let me know the answer
dtCustomer.AsEnumerable.Except(
dtDuplicate.AsEnumerable,DataRowComparer.Default).CopyToDataTable()
can you check it
In my PC is no problem
my output
Customers test.xlsx (95.0 KB)
[Customers test MAIN.xlsx|attachment]
this is my main output
i run flow and it’s succeed
(upload://wdpvQvKEV9N2WdCEkK3c463AX1B.xlsx) (89.4 KB)
but in this screen shot (Rescue Hospitals Pvt Ltd) i =must be going in Duplicate sheet it’s go in CUST_FINAL
so please check again and let me know ANSWER PLEASE SEND ME YOUR FLOW Also with output
Hi, so easy, you can add trim
please send me flow
and output file
hello, please reply.
there are many raw are same in customer and OBSL but going in CUST_FINAL , It must going in Duplicate
