Matching column1

[Kuldeep_Pandey]

I want to match exact column of description not same type
DT_2.AsEnumerable.Where(Function(r) not DT_1.AsEnumerable.Any(Function(r2) r2(“DESCRIPTION”).ToString=r(“Document Number”).ToString)).CopyToDataTable.DefaultView.ToTable(False,{“Document Date”,“Document Number”,“Offset Account Text”,“Amount in Local Currency”})
This i have given in assign activity
71030559 description format will be this

[supermanPunch (Arpan)]

@Kuldeep_Pandey

DT_2.AsEnumerable.Where(Function(r) not DT_1.AsEnumerable.Any(Function(r2) r2(“DESCRIPTION”).ToString=r(“Document Number”).ToString)).CopyToDataTable.DefaultView.ToTable(False,{“Document Date”,“Document Number”,“Offset Account Text”,“Amount in Local Currency”})

Hi @Kuldeep_Pandey ,

Could you let us know what is the operation that you are trying to perform ?

The above Expression Filters rows by where there is a Document Number from DT_2 present in any of the rows of Column DESCRIPTION in DT_1.

Could you let us know if you are receiving any errors ?

[Kuldeep_Pandey]

Yes its giving error

[Kuldeep_Pandey]

Its checking that statement written in description also

[supermanPunch (Arpan)]

@Kuldeep_Pandey ,

Are you writing the data back to the same sheet or a New Sheet ?

If writing to the same sheet, Try Checking by writing to a New sheet and let us know it it works.