Expand my Community achievements bar.

Join us for Adobe Campaign Community Q&A Coffee Break on Thursday, March 7th at 8am PT with Eric Perrin, Gael Mouello, Chakravarthy Kalva, Bruce Swann and Sandra Hausmann.
SOLVED

How to get count of records group by a column

Avatar

Level 1

Hi ,

 

Could some one help to use the aggregate function count to get number of rows based on one particular column. For e.g something like below corresponding to sql.

 

select count(1),testcolumn from testtable group by testcolumn .

so i can get the records liks as below:

test1 100

test2 200

test3 300

1 Accepted Solution

Avatar

Correct answer by
Level 2

Bildschirmfoto 2021-02-10 um 14.27.54.png

you can do a query and then click on "group". You also check the box to Advanced parameters

View solution in original post

2 Replies

Avatar

Correct answer by
Level 2

Bildschirmfoto 2021-02-10 um 14.27.54.png

you can do a query and then click on "group". You also check the box to Advanced parameters

Avatar

Administrator

Hi @kankvats1,

Were you able to resolve this query with the given solution or do you still need more help here? Do let us know.

Thanks!  



Sukrity Wadhwa