Forum Discussion

JustNewbie's avatar
JustNewbie
Helper I
3 years ago
Solved

Unpivot table

Hi,  Currently Table 2 is connected to Table 1. Relationship is One to Many (Table 2 Reference is unique, Table 1 Reference will duplicate.) Now I want to unpivot Column F,G,H,I in Table 2. Problem ...
Need Help
  • Dhairya's avatar
    Dhairya
    3 years ago

    Hey JustNewbie 


    If you are using Table 2 as a slicer then as a workaround you can take a duplicate of Table 2 and unpivot that duplicate table so your Table2(older one without unpivot) will have 1 to many relationships with Table 1 and Duplicate of Table, So by this way you handle this.

    If this works for you then please mark my solution as accepted so that it can help others too. Thank you!

Dhairya's avatar
Dhairya
Solution Supplier
3 years ago

Hey JustNewbie 


If you are using Table 2 as a slicer then as a workaround you can take a duplicate of Table 2 and unpivot that duplicate table so your Table2(older one without unpivot) will have 1 to many relationships with Table 1 and Duplicate of Table, So by this way you handle this.

If this works for you then please mark my solution as accepted so that it can help others too. Thank you!

JustNewbie's avatar
JustNewbie
Helper I
3 years ago

thanks, does it means I need to have table 2 & duplicate table 2 connected to Table 1? 

  • Dhairya's avatar
    Dhairya
    Solution Supplier
    3 years ago

    No relationship will be like
    table2    1 to many      table1
    table2    1 to many      table2 duplicate(unpivoted)

    • Dhairya's avatar
      Dhairya
      Solution Supplier
      3 years ago

      Hey JustNewbie 

      If this works for you then please mark my solution as accepted so that it can help others too. Thank you!