Forum Discussion

stok's avatar
stok
Frequent Visitor
3 years ago

Convert a nested table to a seperate table

Hello everyone,

 

I'm currently working on a small project but I'm stuck on this part.

What I want is a seperate table for each row (as shown in the picture below).

When I click on a table it shows the following:

It's empty for now, but it will contain data soon.

So, my question is: how can I get a seperate table for each row?

Some tips and tricks would be really helpful 🙂

Thanks in advance!

Need Help

4 Replies

  • ppm1's avatar
    ppm1
    Solution Sage
    3 years ago

    That can't be done easily in an automated way. Why do you want to combine the tables? It will greatly complicate your analysis/visualization.

     

    Pat

     

    • stok's avatar
      stok
      Frequent Visitor
      3 years ago

      Hi Pat,

       

      Thanks for the quick reply.

      I do not want to combine all the tables. I want to seperate them, so I can create relationships between them. I'm still learning Power BI, so maybe this is not the right way but this is what came to my mind.

      • ppm1's avatar
        ppm1
        Solution Sage
        3 years ago

        If those tables have the same structure/columns, you should just combine/append them for easier analysis. If each table is different, please describe further.

         

        Pat