I want to update my Linq Query

Help Activities
, ,
1

here i want to update my Linq Query
(From row2 In dt_SAP_Dump.AsEnumerable()
Join row1 In dt_BankStatement.AsEnumerable()
On DateTime.Parse(row2.Field(Of String)(“Pstng Date”)) Equals DateTime.Parse(row1.Field(Of String)(“Payment date”)) And
row2.Field(Of Double)(" Local Crcy Amt") Equals (row1.Field(Of Double)(“Credit”))
Select row2).CopyToDataTable

here is the Query I want to update the Local Crcy Amt where Equals to Credit Or Debit Column I want an OR condition on that whether it match Credit Or Debit Column
After that I Want to check the Text Column Contains some data that’s want to check the Narrative Column If the Text contains in that Narrative Column then its Match and copy the datatable
this is the process I want to Solve

2

@Melbin_Antu,

Try this LINQ.

(From row2 In dt_SAP_Dump.AsEnumerable()
Join row1 In dt_BankStatement.AsEnumerable()
On DateTime.Parse(row2.Field(Of String)("Pstng Date")) Equals DateTime.Parse(row1.Field(Of String)("Payment date")) And
(row2.Field(Of Double)("Local Crcy Amt") Equals row1.Field(Of Double)("Credit") Or 
row2.Field(Of Double)("Local Crcy Amt") Equals row1.Field(Of Double)("Debit"))
Where row1.Field(Of String)("Narrative").Contains(row2.Field(Of String)("Text"))
Select row2).CopyToDataTable

Thanks,
Ashok :slight_smile:

3

Thanks its Working :+1: :+1:

1 Like
4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.