Forum Discussion
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 here is if I unpivot, the reference number in Table 2 will become duplicate and not unique, it affects my Table relationship become many to many. Result will incorrectly display when I create visuals. How do I solve this issue?
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!
4 Replies
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!thanks, does it means I need to have table 2 & duplicate table 2 connected to Table 1?
No relationship will be like
table2 1 to many table1
table2 1 to many table2 duplicate(unpivoted)
