topic Re: How to join 2 fact tables without repeating values in QlikView

How to join 2 fact tables without repeating values

Thu, 06 Nov 2014 14:37:29 GMT

Hi,

I have 2 fact tables and I want to join both of them. Concatenation is not working as we have a 1 required field in first table and other in second table, so we do not get values. So, we tried to join but that will cause redundancy.

What to do?

Thanks

Saurabh

Re: How to join 2 fact tables without repeating values

Thu, 06 Nov 2014 14:38:58 GMT

go with link table

Re: How to join 2 fact tables without repeating values

Thu, 06 Nov 2014 14:40:35 GMT

Hi,

load distinct * from Table1;

concatenate

Load distinct * from table2;

Re: How to join 2 fact tables without repeating values

Thu, 06 Nov 2014 15:13:49 GMT

Could you explain in detail that how it would stop redundancy?

Re: How to join 2 fact tables without repeating values

djsampat — Fri, 07 Nov 2014 06:37:07 GMT

Hi,

Depending on your exact requirement, check link for more information

Understanding Join and Concatenate | Qlikview Cookbook

If this helped you, please mark as Helpful. If it solves your issue, please mark as Answer

Regards

Dhruv