Relation issue in Data Model

[nihhalmca]

Hi All,

There are two tables, Dim has one key value as ProductID. It has values in row wise(1,2,3,4). Fact has one key value as ProductID.

It has values in Column wise unlike Dim_ProductID. So i need to convert Dim_ProductID values into column wise to give relation between Fact_ProductID and Dim_ProductID.

Dim_ProductID                       Dim_ProductID              

1,2,3,4                                         1

                                                   2

                                                   3

                                                   4

Please find the attachment for better understanding.

Thanks,

Nihhal.

[jonathandienst]

... and do precisely what with it?

Qlik Community Tip: Posting Successful Discussion Threads‌

QlikCommunity Tip: How to get answers to your post?

[linusblomberg]

You need to "transpose" Dim. In qlikview you do that with a crosstable load

[linusblomberg]

Or wait, are all the dimension in the same field? then you need to separate them first

[florentina_doga]

hope this help.