Relate Horizontal Columns with List

[Anonymous]

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

[Ashish_Mathur · Accepted solution]

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.

[Anonymous]

worked great, I had over 20 basins, but was able to select them all and unpivot at the same time, thank you so much!

[Ashish_Mathur]

You are welcome.

[Anonymous]

I couldn't have said it better myself!

[Anonymous]

I would denormalize Table 1 if possible (unpivot the Basin A, Basin B, and Basin C columns), then connect the two tables via a 1:n relationship on Basin.

Denormalized Table 1