Getting data from a different Table

[RohitMadaan]

Table 1

ID	brand	price
1	ABC	133
1	DEF	266
1	GHI	399
2	ABC	100
2	DEF	200
2	GHI	300
3	ABC	400

Table 2:

ID	ABC	DEF	GHI
1	?	?	?
2	?	?	?
3	?	?	?
4	?	?	?
5	?	?	?

There are two tables: 1 & 2 and both have a relationship of one to many. I am trying to get data (Price: column 3 from table 1 fo specific brand and ID to table 2 in column 2-4 for those IDs.

Thanks in Advance!  

[v-jayw-msft · Accepted solution]

Hi @RohitMadaan ,

What does Table 2 look like? 

If you want a visual, you could create a matrix as below.

If you want a table, you could duplicate the table and select brand column and use pivot feature.

Best Regards,

Jay

[camargos88]

@RohitMadaan ,

Does it work if you unpivot the last 3 column from table 3 ?

So you can create a relationship and navigate on it.

[RohitMadaan]

@camargos88It won't work as the data in ID column is not the same type.

What i could think of is using Related function but somehow not able to reach to the conclusion.