Help on Getting correct row from Datatable

I am taking a queue item, comparing it against a Dt and then getting a value variance and percent variance. I then want to combine the line item from the Dt and the info from the queue item into a DtNewRow and add it to a Dtbuild. Then append it to a running excel db that documents all comparisons. The issue I have is that the in_transaction item data and calculations are gathered fine but the Dt info picks up the last line in the Dt and not the Dt that matches the in_TransactionItem. How do I get the specific line of the Dt into the DtNew Row. I am using a for each loop with a dtNewRow multi-assign outside of the for each loop.

solved with a workaround in excel

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