Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
nihhalmca
Specialist II
Specialist II

Relation issue in Data Model

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.

4 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

... and do precisely what with it?

Qlik Community Tip: Posting Successful Discussion Threads

QlikCommunity Tip: How to get answers to your post?

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
linusblomberg
Creator II
Creator II

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

linusblomberg
Creator II
Creator II

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

florentina_doga
Partner - Creator III
Partner - Creator III

hope this help.