How to group the data

Help
1

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!

2

Hi
Hope this would help you buddy

Cheers @mashy2

3

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

4

What was the input passed buddy
Cheers @mashy2

5

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.

6

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

7

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:

8

hi @samir,

I change the datatable into this:
image

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

image

9

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:

updated
updated845Ă—188 9.03 KB

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
10

Thank so much!!!

11

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