DataTable Comparision

[naveen19 (Learner)]

am having 2 DT

1. Daily DT - > which is change on daily basis
2. Master DT - > writing the processed DT

DT1:
Policyno state exp.date
123 Ind 09/07/2020
156 Ind 05/07/2020
129 Ind 09/08/2020
1642 Ind 07/07/2020

DT2:(master)
Policyno state exp.date Status botrun_Date
123 Ind 09/07/2020 Completed 08/03/2020
156 Ind 05/07/2020 Failed 08/02/2020
129 Ind 09/08/2020 Failed 08/01/2020
1642 Ind 07/07/2020 completed 08/04.2020

i want to compare the DT1 with MasterDT
condition :

1. policy no matched in both DT and status is completed → skip the row
2. policy no matched in both DT and status contains the values other than complated(like failed) and botrun_date is not today i want to consider that row for the process.

can anyone help me by sharing xaml.

thanks

[Vishal_K]

Hi @naveen19

Find this working xaml file
naveen19.zip (9.5 KB)

Output Screenshot

Note : If by chance you get “ CopyToDataTable is not a member of datatable ” issue then this link will help you to fix: AsEnumerable is not a member of ‘System.Data.Datatable’ Note

[naveen19 (Learner)]

Thanks lot @Vishal_K its working

[naveen19 (Learner)]

@Vishal_K bro when i try to merge the results with dailyDT am getting error as
Merge Data Table: .Policy and .Policy have conflicting properties: DataType property mismatch.
eventhough my headers are same