topic Re: Fact tables , different granularities in QlikView https://community.qlik.com/t5/QlikView/Fact-tables-different-granularities/m-p/943467#M646854 <HTML><HEAD></HEAD><BODY><P>Because the volumes are getting seriously bigger by the day , estimatiopn of (500 million rows) for Table1+ 100 million for table2</P></BODY></HTML> Fri, 09 Oct 2015 15:06:22 GMT 2015-10-09T15:06:22Z Fact tables , different granularities https://community.qlik.com/t5/QlikView/Fact-tables-different-granularities/m-p/943463#M646846 <HTML><HEAD></HEAD><BODY><P>Hello</P><P></P><P>How can I load two Fact&nbsp; tables into one Fact table , without concatenating them , their granularities are different ( one level of difference) as described bellow.</P><P><IMG alt="Tables.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/101537_Tables.png" style="height: 45px; width: 620px;" /></P><P>Table 1 one however will be meant to calculate distinct IDS (150 Million rows) and the other would be around (50million rows) and would calculate Total sums </P><P></P><P>I would however load data in a monthly manner but still is there anyway to join both table and have the actual correct Total sums</P><P></P><P>Thank you for your help</P></BODY></HTML> Fri, 09 Oct 2015 08:36:00 GMT https://community.qlik.com/t5/QlikView/Fact-tables-different-granularities/m-p/943463#M646846 2015-10-09T08:36:00Z Re: Fact tables , different granularities https://community.qlik.com/t5/QlikView/Fact-tables-different-granularities/m-p/943464#M646849 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>See <A _jive_internal="true" data-containerid="2588" data-containertype="37" data-objectid="2819" data-objecttype="38" href="https://community.qlik.com/blogs/qlikviewdesignblog/2012/10/26/mixed-granularity">http://community.qlik.com/blogs/qlikviewdesignblog/2012/10/26/mixed-granularity</A></P></BODY></HTML> Fri, 09 Oct 2015 09:29:42 GMT https://community.qlik.com/t5/QlikView/Fact-tables-different-granularities/m-p/943464#M646849 Gabriel 2015-10-09T09:29:42Z Re: Fact tables , different granularities https://community.qlik.com/t5/QlikView/Fact-tables-different-granularities/m-p/943465#M646852 <HTML><HEAD></HEAD><BODY><P>The short answer is use CONCATENATE prefix before your LOAD statement to force them into the same table.</P></BODY></HTML> Fri, 09 Oct 2015 13:00:34 GMT https://community.qlik.com/t5/QlikView/Fact-tables-different-granularities/m-p/943465#M646852 petter 2015-10-09T13:00:34Z Re: Fact tables , different granularities https://community.qlik.com/t5/QlikView/Fact-tables-different-granularities/m-p/943466#M646853 <HTML><HEAD></HEAD><BODY><P>Why "<EM>...</EM><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><EM>without concatenating them...</EM>" ? </SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">What's wrong with that ?</SPAN></P><P></P><P>Peter</P></BODY></HTML> Fri, 09 Oct 2015 14:24:51 GMT https://community.qlik.com/t5/QlikView/Fact-tables-different-granularities/m-p/943466#M646853 Peter_Cammaert 2015-10-09T14:24:51Z Re: Fact tables , different granularities https://community.qlik.com/t5/QlikView/Fact-tables-different-granularities/m-p/943467#M646854 <HTML><HEAD></HEAD><BODY><P>Because the volumes are getting seriously bigger by the day , estimatiopn of (500 million rows) for Table1+ 100 million for table2</P></BODY></HTML> Fri, 09 Oct 2015 15:06:22 GMT https://community.qlik.com/t5/QlikView/Fact-tables-different-granularities/m-p/943467#M646854 2015-10-09T15:06:22Z