Remove character and format date in DataTable

[marina.dutta]

@mkankatala

Compare two DataTable Column Values and see If there is match Using LINQ

Hi All, I want to compare all the columns of two DataTable DT1 and DT2 Column Values using LINQ query and find out the column values which are matching and the column values which are not matching and output the unmatched column values in another DataTable. Need to remove any special characters in column values and check for exact match . [image] [image] Salesforce_Output.xlsx (6.8 KB) Results.xlsx (8.5 KB)