I have two excel files from both files I have to compare Actual data and the expected data where I will be having more number of rows and columns So the execution should be fast as the output result I need if the data’s is not matched from both the sheet which column value is not matching and those column names and I will be having Case ID as a unique for the both the sheets so that case ID I need as output
I don’t want to use nested for each loop because I have rows in thousands so this approach will be time consuming
If you have more rows in the excel, then you can use the LINQ Expressions to compare between the two excels and pull the required data.
But your query is quite confusing provide us the two excel files and output excel file, elaborate the conditions more then we are able to write the LINQ Expression.
Hi @Yoichi and @mkankatala,
I can provide a screenshot of dummy data in that you can find actual data and expected data where I will be having the same columns in the two excel files so I have to compare this two files if the data is not matching I have to get those mismatched data and their respective column names and their Case Number which in the first column in this way I will be having huge number of rows. Could you please help me with the LINQ Query.
Expected Output: Mismatching values and their column names and the Case Number I have to get this information.
