Group data from excel table with same values and store them in for each loop to store to pass web form

[Yusuf_Rahmaniac]

hi goodday, i have this scenario where i have to group an excel data by a single value and pass them to a web form by group in this pic, i have the data so i have to group data by name and pass the corresponding information by name. suppose in table, Bella has two rows , kristen has two rows and charlie has one row. i have to input data by bella only then followed by kristen and then charlie. the order does not matter as long as i input the information by name. i will be very grateful if i could get some answer for this.Thank you very much.

[Mr_Meeseeks (Dan Fishkin)]

@Yusuf_Rahmaniac

Can Do! Let’s try a Read Range activity followed by Sort Data Table

Sequence.xaml (5.2 KB)

[ppr (Peter Preuss)]

@Yusuf_Rahmaniac

have a look on the folling posts, as they are handling quite similar scenario:

Iterate DT For Each Group

@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 I…

Isolate multiple rows with duplicate column values

Say I have the following table: [image] How should I isolate the rows where the first 4 column values are the same (So the rows highlighted in yellow and orange) ? I want to store all the ones with duplicates into a separate sheet and the ones without duplicates into another sheet I looked at this link but the method in here does not do exactly what I need to do, (Remove Duplicate Rows By Combination of Multiple Column Values)