multiple Groups shown in just one column

WorldWarHulk
WorldWarHulk Member
in Magic ETL

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!

Tagged:

Best Answer

  • ColemenWilson
    ColemenWilson Coach
    edited June 2024 Answer ✓

    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.

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

Answers

  • ColemenWilson
    ColemenWilson Coach

    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
    WorldWarHulk Member

    basically, this is what we want to see»>

    sample.jpg
  • ColemenWilson
    ColemenWilson Coach
    edited June 2024 Answer ✓

    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.

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

Categories