Forum Discussion
andykbba
2 years agoRegular Visitor
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...
andykbba
2 years agoRegular Visitor
Hi thanks for this suggestion,
When I do this it provides me with the following error.
Ashish_Mathur
2 years agoSuper User
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.