Grouping the data row based

[rsathish47]

HI All,

I need to group the data row based my table looks like this.

Table:

DBName Region Dag count

DB1 US DG1 3

DB1 EUR DG1 5

DB2 US DG3 4

DB3 EUR DG2 5

DB3 US DG2 3

DB3 Ap DG2 6

Result Table

DBName Region Dag count

DB1 US,EUR DG1,DG1 3,5

DB2 US DG3 4

DB3 EUR,US,Ap DG2,DB2,DB2 5,6,3

Please let me know if their any workaround

Thanks
Sathish R

[somesoni2]

Similar, but formatted as per your example:

..your base search...| stats delim="," values(Region) as Region values(Dag) as Dag values(count) as count by DBName | nomv Region | nomv Dag | nomv count

[adityapavan18]

Could you try like

| stats values(Region) as Region values(Dag) as Dag values(count) as count by DBName.

you can also use list instead of values.