Forum Discussion
Relate Horizontal Columns with List
Hi all,
I have a list of time-stepped data and I'm trying to create a slicer so that I can filter the data without having to drag and drop it each time. I can't think of a way to create a relationship without having to create a singular relationship for each field? Example Below:
Table 1
| Day | Basin A | Basin B | Basin C |
3/1/20 | 1 | 4 | 6 |
| 3/2/20 | 3 | 2 | 4 |
| 3/3/20 | 5 | 4 | 3 |
| 3/4/20 | 2 | 1 | 6 |
Table 2
| Basins |
| Basin A |
| Basin B |
| Basin C |
Hi,
In the Query Editor, right click on the first column on Table1 and select "Unpivot other columns". Now create a relationship (Many to One and Single) between Table2 and the Attribute column of Table1.
Hope this helps.
5 Replies
Hi,
In the Query Editor, right click on the first column on Table1 and select "Unpivot other columns". Now create a relationship (Many to One and Single) between Table2 and the Attribute column of Table1.
Hope this helps.
You are welcome.