Get line items from the input

Hello all.
I have an automation problem.
My input has 2 sheets (HeaderData and LineItems).
Each row of header data has multiple line items( which has to be entered into a table).

How to get these line items as a data table ( or any type) so that I can enter into the table.

ExampleInput.xlsx (10.3 KB)


How about using Dictionary as the following?

dict = dtLineItem.AsEnumerable.GroupBy(Function(r) r("No").ToString).ToDictionary(Function(g) g.Key,Function(g) g.CopyToDataTable)

dict is Dictionary<string,DataTable> type (11.3 KB)


1 Like

Thanks for the solution.
I’ll try this and mark it as resolved.

Hi @Yoichi .I am trying to implement this in Re-Frame work ( Without queues), but facing it challenging. (2.3 MB)
Could you please check this?

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