Hi, i have 2 dataTable which you can find in the excel “Sheet1” and “Sheet2”. As you can see these dataTables have different columns. I need to compare these dataTables and take only the different values regarding only for 2 column’s values.
Example; in Shet1 - H3:I7 (range) - there are same values in Sheet2 but The column “Oran” and “Tutar” are different at some of them. So in a nutshell i need to filter the dataTable Sheet1 according to the “Tutar” and “Oran” column’s values for same rows. Could you help me on that, please?
sample.xlsx (16.3 KB)
*the result ; the result should give me the row4,6 and 7 in Sheet1. Because the values in it “Tutar” same in Sheet2 but “Oran” is different.
- if you can do that with LINQ methods or query syntax, it would be great for me