Forum Discussion

andykbba's avatar
andykbba
Regular Visitor
2 years ago

Top N Filter

Hi all, I have some general Australian Bureau of Statistics Data. Essentially I have the location of a place in Australia  (in one column)     And 19 other columns which show how m...
Need Help
Show and Tell
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
2 years ago

Hi,

In the Query Editor, select the Location column, right click and select "Unpivot Other Columns".  Click on Close and Apply.  Work with this transformed dataset.

  • andykbba's avatar
    andykbba
    Regular Visitor
    2 years ago

    Hi thanks for this suggestion, 

    When I do this it provides me with the following error. 

     






    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      2 years ago

      On unpivoting, entries in the location column are repeating causing the Many to One relationship to fail.  Create a Location Dim Table which should only have all the unique locations.  Create Many to One relationships to this Location dim table.