If the Employee Code in DataTable ‘dt1’ is not present in DataTable ‘dt2’, the corresponding row will be written to ‘resultdt’, and this line item will be iterated over the period from ‘01.08.2023’ (start date) to ‘31.08.2023’ (end date).
please provide solution
input -dt1
input -dt2
result
Just use Join Data Table (left) with Employee Code = EMPNR.
The resulting datatable will have columns from both tables. Then you can use Filter Data Table (keep) on EMPNR is blank. Now the datatable will just have the rows from dt1 that aren’t in dt2.
@sivaramana.relangi , Hi Sivaraman, you can use below linq query and looping the dates to achive the result and also attached the workflow file for your reference please find
ForumQuestions_Answers.zip (12.2 KB)
,
dt1.AsEnumerable().Where(Function(row) Not dt2.AsEnumerable().Any(Function(r) r.Field(Of String)(“EMPNR”) = row.Field(Of String)(“Employee Code”))).CopyToDataTable().DefaultView.ToTable(False, “Profile Name”, “Employee Code”)