Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Fact tables , different granularities

Hello

How can I load two Fact  tables into one Fact table , without concatenating them , their granularities are different ( one level of difference) as described bellow.

Tables.png

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

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

Thank you for your help

4 Replies
Gabriel
Valued Contributor II

Re: Fact tables , different granularities

MVP
MVP

Re: Fact tables , different granularities

The short answer is use CONCATENATE prefix before your LOAD statement to force them into the same table.

Re: Fact tables , different granularities

Why "...without concatenating them..." ?

What's wrong with that ?

Peter

Not applicable

Re: Fact tables , different granularities

Because the volumes are getting seriously bigger by the day , estimatiopn of (500 million rows) for Table1+ 100 million for table2

Community Browser