How to group the data

Hi All,

Is there any suggestion on how to group this?

Assuming Number is dynamic, while Pmt Mthd is specific (AUTO DEBIT OR CREDIT CARD):


Desired Output:


Thanks so much!

Hope this would help you buddy

Cheers @mashy2

Hi, Unfortunately when i try it out, it gave error such as wrong input string.

What was the input passed buddy
Cheers @mashy2

hii @mashy2
I’m attaching my workflow here, Unique&Count.xaml (10.4 KB)
You’ll get the idea.
here’s the result
Go through that xaml, I’ve attached and I hope it’ll help you.


Thank you so much,

but can i know why it gave this error:

Assign : Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index

This is string list:


hey @mashy2
I don’t know, where you’ve got this error but, usually that means you’re trying to index an object with a value that was not valid (not there in collection) :slight_smile:

hi @samir,

I change the datatable into this:

Why does it count bbb,100 as 3 instead of 1?


yeah, @mashy2 you’re right,
this happened because I’ve grouped data according to Name only,
So to get the correct output I’d done one change in Linq query as shown in below shot:

here you can see now I’ve grouped according to “Name” as well as “Number”, it gives correct output.
here’s the updated workflow, Unique&Count.xaml (10.5 KB)
for your better understanding. :slight_smile:


Thank so much!!!

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.