multiple Groups shown in just one column

WorldWarHulk · 2024-06-04T16:24:45+00:00

There was an error rendering this rich post.

Hello DOMO -

Good Day!

I am using the Data governance dataset that has the users and groups.

what we wanted to show is the pages/dashboard and then all the groups that can view it.

currently, I can show the different pages and the different groups in different columns.

just wanted to know if we can show all the different groups that we have in just one column?

Thanks!

Find more posts tagged with

Cards

Dataset

Magic ETL

Beast Mode

Accepted answers

ColemenWilson

Yep then Group Concat is the way to go! See a basic MagicETL setup below (just swap `state` for `Page` and `Sales Rep` for `Group`:

Screenshot 2024-06-04 at 12.24.02 PM.png

If you are using MySQL dataflow instead, use GROUP_CONCAT() and be sure to have a GROUP BY `page` in your query.

All comments

ColemenWilson

I am not sure exactly the format you are hoping to have, but if you could provide a screenshot or a data table from excel or something showing the format I could help out.

I think maybe you are looking for a concatentation into a single column, which you could accomplish using GROUP_CONCAT() https://www.w3resource.com/mysql/aggregate-functions-and-grouping/aggregate-functions-and-grouping-group_concat.php

You could do this in a MySQL dataflow or using the Group by tile in Magic ETL

WorldWarHulk

basically, this is what we want to see»>

ColemenWilson

Yep then Group Concat is the way to go! See a basic MagicETL setup below (just swap `state` for `Page` and `Sales Rep` for `Group`:

If you are using MySQL dataflow instead, use GROUP_CONCAT() and be sure to have a GROUP BY `page` in your query.