How to join 2 fact tables without repeating values

[#1]

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

[#2]

go with link table

[#3]

Hi,

load distinct * from Table1;

concatenate

Load distinct * from table2;

[#4]

Hi

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

[djsampat]

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