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)
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.
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.
if u completed can you share this task xmal files…?
I have attached the task xmal file.
Please let me know if you need more information.
Prince KumarExcel Comparision.xaml (25.9 KB)