Vlookup uisng linq

[anilkumar_raj]

Hello team I need one solution
Using this below condition if value is matched I need to write matched if value is not matched need to write not matched.

Where we need add matched and where we need to not matched

[ppr (Peter Preuss)]

As a column update / datatable construction is to do, we need to refer to the different column structures.

Can you share some samples for the two input tables and the expected output? Thanks

ADDED: References

Do a vlookup using LINQ and assign the value to the specified column

better not change structures during a code integrations. This will affect the indexes. Better do it after a prototype is running successfully. A datrow has an ItemArray which is an array of object holding the values from the columns Let slsa = If(isNothing(g), Nothing, g(1)) an explicit check if the left join had a match and taking the value from second column (AgeingDt Amount) Let rapre = a.ItemArray.Take(2).Append(slsa) creating a part result by taking the first 2 items from itemarray an…

Do a vlookup using LINQ and assign the value to the specified column

better not change structures during a code integrations. This will affect the indexes. Better do it after a prototype is running successfully. A datrow has an ItemArray which is an array of object holding the values from the columns Let slsa = If(isNothing(g), Nothing, g(1)) an explicit check if the left join had a match and taking the value from second column (AgeingDt Amount) Let rapre = a.ItemArray.Take(2).Append(slsa) creating a part result by taking the first 2 items from itemarray an…

[anilkumar_raj]

Actually I am using above condition for vlookup between 2 data tables ,so If it’s matched I need to write matched in other column if it’s not matched write not matched in other column

[anilkumar_raj]

I tried this but no luck if I use this condition

Let slsa=if(nothing(g), nothing,g(1))

Instead of nothing I tried

Let slsa=if(nothing(g), not matched,g(1)) it’s working

But I need matched also

[pravallikapaluri]

Hi @anilkumar_raj

Try this

(From a In collectionsDT.AsEnumerable()
 Group Join b In AgeingDT.AsEnumerable()
 On a("Bank Invoice") Equals b("Document Number") Into gj = Group
 From g In gj.DefaultIfEmpty
 Let slsa = If(isNothing(g), Nothing, g(1))
 Let rapre = a.ItemArray.Take(2).Append(slsa)
 Let rapost = a.ItemArray.Skip(3)
 Let ra = rapre.Concat(rapost).ToArray()
 Let matchStatus = If(isNothing(g), "Not Matched", "Matched")
 Select r = dtResult.Rows.Add(ra.Concat({matchStatus}).ToArray())
).CopyToDataTable()