Iterate DT For Each Group

Help
11

@COOLBOT
Just a little starter help:

Readin the Excel into a DataTable - Read Range

  • e.g. Variablename: dtData - Assumption Column Order is of DataType: Int32

Creating a list of Groups (Distinct Orders) - Assign Activity
grafik

  • DataType Orders: List(Of Int32)
  • Statement: dtDemo.AsEnumerable.Select(Function (row) row.Field(Of Int32)(“Order”)).Distinct().ToList

Iterate over the Groups

Filter the original DataTable to all Rows belonging to the Current Group from Iteration - dtFiltered

Iterate over all Rows from dtFiltered

  • do your processing e.g. Entering the Data (In Screenshot show cased with a Log Message)
    grafik