I can't able to write data into write range workbook activity?

Help Studio
, ,
1

here iam having 2 excel sheets as inputs and read them using the filter datatable condition then i used write range work book to check matching or not? but iam not able see any data into new excel sheet which is output sheet after conditions?

please go through the my workflow
TestVersion of MIR7 Validation.zip (31.5 KB)

2

Hi @Naveen_Kanike

Instead of using Filter Data Table within For Each row in DataTable use the below LINQ expression:

MatchingDT = PODT.AsEnumerable().Where(Function(row1) InvoiceDT.AsEnumerable().Any(Function(row2)
row1("PO Numbers").ToString() = row2("PO Number").ToString() And 
row1("Quantity").ToString() = row2("Quantity").ToString() And 
row1("Unit Price").ToString() = row2("Unit Price").ToString() And 
row1("Currency").ToString() = row2("Currency").ToString() And 
row1("Gross Value ").ToString() = row2("Total Price").ToString() And 
row1("Total").ToString() = row2("Total amount").ToString() And
row1("Additional cost").ToString() = row2("Additional Cost").ToString())).CopyToDataTable()

Updated the workflow according to above query and Output.xlsx is the Output sheet.
TestVersion of MIR7 Validation.zip (177.0 KB)

Regards

4

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