multiple Groups shown in just one column

Options

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!

Best Answer

  • ColemenWilson
    edited June 4 Answer ✓
    Options

    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.

    If I solved your problem, please select "yes" above

Answers

  • ColemenWilson
    Options

    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

    If I solved your problem, please select "yes" above

  • WorldWarHulk
    Options

    basically, this is what we want to see»>

  • ColemenWilson
    edited June 4 Answer ✓
    Options

    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.

    If I solved your problem, please select "yes" above