Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to work on two or more fact tables in our model ....? can anyone tell me best solution to create best datamodel?

Hi All,

How to work on two or more fact tables in our model ....?

can anyone tell me best solution to create best datamodel?

Help me...

Ramaya.

1 Solution

Accepted Solutions
MayilVahanan

Hi

Please refer below link to understand

Concatenate vs Link Table

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

6 Replies
Anonymous
Not applicable
Author

one solution would be to have  1 fact table (by concatenating) the data of the two facts into one.

other solution would be a link table between the two fact tables.

there are other Solutions as well

there is no "best" solution. it depends on many things

Not applicable
Author

Thanks for your reply,

Kindly give practical explanation and etc.....

Please...

Ramaya.

Anonymous
Not applicable
Author

a Little bit difficult without further info

if you have fact table 1 you Need to concatenate fact table 2

Fact1:

concatenate

load *

resident Fact2

drop table Fact2

But you Need to have the same Name for the common Dimension (at least you should rename them in the Facts so they are identical ´,- e.g Dim1 in both fact tables and not Dim1 in one and DIm1a in other)

can you post sampe qvw?

MayilVahanan

Hi

Please refer below link to understand

Concatenate vs Link Table

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Not applicable
Author

Thank you Mayil Vahanan Ramasaamy.....

it's more helpful......

Ramaya

MayilVahanan

No problem. Close this thread

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.