How to group datatable values based on common criteria and manipulate them as a group

[gabrielespinosa (GabrielME)]

Hello,

I have an excel sheet with lets say 100 rows of data. I need to input into SAP each of those 100 rows of data. However, if the account number is the same, then they should all be input at the same time within the same SAP invoice entry.

This makes it impossible (I think?) to use a for each, because I cannot iterate through each row and input the data. I was wondering if there is a way to go through the data, and identify and separate the data that should be together. This would be similar to adding a filter in excel and going through each filter group.

Any way to do this? The number of rows can change and some days there may not be any accounts with more than 1 line (in that case a simple for each works). As of now. I created a robot which identifies “single” entries and “multiple line entries”. I then create 2 datatables and use for each to input the “single line entries” into SAP. I can’t figure out what to do for multiple lines!!!

[Yoichi]

Hi,

I think we can achieve it using GroupBy method etc. Can you share sample data?

Regards,

[ppr (Peter)]

[HowTo] Overview on different options for grouping data and processing the groups

This HowTo introduces on the different options for grouping data from a datatable in order to process the grouped data. Introduction Grouping data and processing the grouped data is a common scenario e.g. when the grouped data is to aggregate like summing up, find maximum, get the average or concatening items. Lets have a look on following data: [grafik] A possible scenario could be: Create a report containing following information: the region code the sum of CaseCount per RegionCode t…