How do I group similar data into separate files?

in general it is about grouping the data on the category:

Assign Activity:
LHS: TableList | DataType: List(Of DataTable)

(From d in YourDataTableVar.AsEnumerable
Group d by k=d(“Category”).toString.Trim into=grp
Select t = grp.CopyToDataTable).toList

For each Activity - TypeArgument: DataTable Values: TableList

  • iterate over DataTables from TableList
    • e.g use output DataTable Activity to generate a Text representation of the loop datatable
    • write it to a text file