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):

image

Desired Output:

image

Thanks so much!

Hi
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.
data
here’s the result
result
Go through that xaml, I’ve attached and I hope it’ll help you.

Hi,

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:

image

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:
image

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

image

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:

2 Likes

Thank so much!!!

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