Comparing 2 Excel and saving the result in another excel

excel
activities

#1

Hello All,

I have created a flow which will read two excel and compare them and if in first excel it doesn’t find anything then it will save the data in a another excel. I am able to run it for what is available but I need to run it for whats not present in file 1st and present in 2nd file. But not able to run the same.

COuld you please help. I have uploaded the xmal file and the excels.

Excel 1.xlsx (8.0 KB)
Excel 2.xlsx (7.8 KB)
Excel Comparision.xaml (22.1 KB)


#2

Hi @prince.kumar.singh,

1.using Read cell activity read the first sheet cell(A1) and store int into some fields (str_first)
2.using Read cell activity read the second sheet cell(A1) and store int into some fields (str_second)
if str_First is not empty

  • Read the first sheet store it into Datatable (dt_Firat)

if str_Second is not empty

  • Read the first sheet store it into Datatable (dt_Second)

3.if str_First is empty

  • you can take dt_second is the final output

4.if str_Second is empty

  • you can take dt_First is the final output

5.if str_First and str_Second is not empty

  • compare the two datatable and get the output.

Regards,
Arivu


#3

Thanks @arivu96.

I was able to create the workflow adding a boolean variable in between and keep changing its value when a match is found and update the excel with write cell and keep a index to go to next cell when new value is found.


#4

if u completed can you share this task xmal files…?


#5

Hello @pratapg,

I have attached the task xmal file.

Please let me know if you need more information.

Regards,
Prince KumarExcel Comparision.xaml (25.9 KB)