How to match the rows from 3 excel sheets?

Help Studio
, ,
1

Hi team,

Hi i have written code like this now could able change the variable type and this code also not working fine i don’t why ?Please so one help me ??

(From row1 In inv9dt.AsEnumerable()
Join row2 In podt.AsEnumerable()
On row1(“Po_Number”).ToString().Replace(“/”, “”) Equals row2(“PO_Number”).ToString().Replace(“/”, “”)
Join row3 In bldt.AsEnumerable()
On row1(“Supplier_Name”).ToString() Equals row3(“Shipper_Name”).ToString()
Select New Object() {
row1(“Invoice_No”), row1(“Po_Number”), row1(“Supplier_Name”), row1(“HS_Code”),
row1(“Quantity”), row1(“Unit_Price”), row1(“Amount”), row1(“Total”), row1(“Currancy”),
row2(“Terms_of_Delivery”),
row3(“Bill_No”), row3(“Shipper_Name”)
}).ToList()

2

@naveen5 Try this:

Dim matchedRows = From row1 In inv9dt.AsEnumerable()
Join row2 In podt.AsEnumerable()
On row1(“Po_Number”).ToString().Replace(“/”, “”).Trim().ToLower() Equals row2(“PO_Number”).ToString().Replace(“/”, “”).Trim().ToLower()
Join row3 In bldt.AsEnumerable()
On row1(“Supplier_Name”).ToString().Trim().ToLower() Equals row3(“Shipper_Name”).ToString().Trim().ToLower()
Select New Object() {
row1(“Invoice_No”),
row1(“Po_Number”),
row1(“Supplier_Name”),
row1(“HS_Code”),
row1(“Quantity”),
row1(“Unit_Price”),
row1(“Amount”),
row1(“Total”),
row1(“Currancy”),
row2(“Terms_of_Delivery”),
row3(“Bill_No”),
row3(“Shipper_Name”)
}

Dim resultList = matchedRows.ToList()

3

can u connect if possible?