Get line items from the input

[Dinesh_Babu_S]

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)

[Yoichi]

Hi,

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

Sample20230112-3L.zip (11.3 KB)

Regards,

[Dinesh_Babu_S]

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

[Dinesh_Babu_S]

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