Delete Rows from a datatable after comparing with another datatable

[Shikhar_Tandon]

Hi Champs,

It would be a great help if someone could guide me on my problem.
I have a datatable which consists of an IF condition and when that IF condition is true I want to match this datatable rows with the main table and then want to remove these rows .
Any leads will be very Helpful.

Thanks!!

[Palaniyappan (Palaniyappan P)]

Instead we can get the records we want from the second table alone that too the matching records alone, with JOIN DATATABLE activity having left join
Cheers @Shikhar_Tandon

[Shikhar_Tandon]

Thanks for the reply @Palaniyappan , Actually the main table consists of all the records. I Took some records manipulated them and then my work is finish so i want to remove that records or rows from the main table and then want to print the updated main table somewhere else.Can join help in this case ?

[Palaniyappan (Palaniyappan P)]

Fine got it,
Did we try with linq query like this once after getting the datatable from both the excel files

dt_NonMatched_Data = In_DataTable1.AsEnumerable().Where(function(row) Not In_DataTable2.AsEnumerable().Select(function® r.Field(Of String)(In_DT2_ColName_To_Match.ToString)).Any(function(x) x = row.Field(Of String)(In_DT1_ColName_To_Match.ToString))).CopyToDataTable()

Cheers @Shikhar_Tandon

[AndersJensen]

How to remove a row a row in one excel by comparing in another excel

Hi There, I am trying to remove a data row of 10 columns in excel A and comparing with the data of excel B with 3 columns. If the data in column 1 of excel B present in the column of excel A. I want to delete the data in Excel A. I tried: Creating two data tables DT1 and DT2 and used activity remove data row. Data is not deleting. Any help is appreciated. Thank you.