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 ...
Need Help
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

      • stok's avatar
        stok
        Frequent Visitor
        3 years ago

        Each table is different. So they all have unique columns.