Copy multiple columns if value match

[jenkim (Jane)]

Hi all,

I wanted to compare excel file between today’s file and yesterday excel file. Column name will stay the same. From today’s excel file and I will match it with yesterday’s excel by using “Column 1” and if it’s match then I will copy the data from yesterday’s file from column 6 until column 9. If it does not found the match it will just skip the row.

Please help me on this.

Today’s Excel File:

Yesterday’s Excel File:

[Pratik_Wavhal]

Hi @jenkim

For the above que you mean to say that
If the value of “A2” from Today’s Excel File matches with the value of “A2” from Yesterday’s Excel File then, the data From the Yesterdays Excel File starts from “F2” to “I2” should get write to Today’s Excel File Columns i.e from “F2” to “I2”

Right ??

[jenkim (Jane)]

Yes correct. Do you have any idea how to do it?

[Pratik_Wavhal]

Hi @jenkim

Yes
I just now worked on it to provide you the solution
Main.xaml (18.7 KB)
project.json (1011 Bytes)
Today’s Excel File.xlsx (8.9 KB)
Yesterday’s Excel File.xlsx (8.8 KB)

Hope this may help to solve your issue
Mark as solution if this helps you and like it

Happy Automation

Best Regards
Er Pratik Wavhal

[Pratik_Wavhal]

Hi @jenkim

Below is the output for your query after running the process which i have shared

Today’s Excel File :-

Yesterday’s Excel File :-

Hope this may help to solve your issue
Mark as solution if this helps you and like it

Happy Automation

Best Regards
Er Pratik Wavhal

[jenkim (Jane)]

Thank you so much for your help. I’m currently away so I’m unable to test it. Will test it right away after I got back.

[Pratik_Wavhal]

Hi @jenkim

No Worries

Kindly check when you will go through it & let me know.

And if my solution solves your query then do Mark it as solution

Happy Automation

Best Regards
Er Pratik Wavhal

[jenkim (Jane)]

Hi Pratik,

I just check on your solution and it actually doesn’t work correctly. But thank you for your effort on this.

Yesterday’s File

After I run the process and the result for today’s file:

Which as you can see supposedly row 5 of column 1 should have data in it and row 4 should not have any data since it doesn’t exist in yesterday’s file.

[Pratik_Wavhal]

Hi @jenkim

The issue has been solved in the below updated Main1.xaml File
Plzz have a look on it n let me know
Main1.xaml (20.7 KB)

I have attached the SS also by running the workflow n now it gives the output you want.
Yesterday’s Excel File :-

Today’s Excel File :-

Hope this workflow may help you to solve your issue
Mark as solution if this helps you and like it

Happy Automation

Best Regards
Er Pratik Wavhal

[jenkim (Jane)]

Thank you so much and it works perfectly.

Have a good day.

[Pratik_Wavhal]

You are Welcome @jenkim

Happy Automation

Best Regards
Er Pratik Wavhal