Hello,
I want to extract the other date from sheet2 according to these dates in sheet1 sheet, which has 4 dates in Excel.
Hi @burak
Read both of them into two datatables
Use a for each data row on the first table
Use filter datatatble inside the loop to filter then rows in second datatable
cheers
can you show the filter data structure?
Hi @burak
This is how it looks
add currentRow(“Date”).ToString if this is not filtering properly
cheers
Hi @burak
If possible can you share the sample excel file with the expected output
Check out this blog
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.