2 Replies Latest reply: Jun 6, 2018 3:30 AM by Marcus Sommer RSS

    Fact Table Issue In Qlik Sense

    Villyee Anderson

      I have 4 fact tables, these fact tables contains 50% same fields but others fields are different, I need suggestion can i concatenate 4 table into single one or is there any other option we have?

       

      Thanks,

      Villyee

        • Re: Fact Table Issue In Qlik Sense
          David Forest

          Best practice would probably be to either create a composite key to join on to resolve the multiple synthetic keys that would otherwise be generated.

          Another possibility would be to join them if they all contain records for the same key.

          • Re: Fact Table Issue In Qlik Sense
            Marcus Sommer

            In general you could concatenate the fact-tables and quite often it will work well (and usually the resulting NULL's from the asynchron merging of the tables won't bother in any way). But it will depend on a lot of factors if this way is the most suitable for your amount of data and all your requirements.

             

            Another approach would be to associate these tables directly and/or per link-tables with eachother - but in many cases it will have more disadvantages as benefits and I would at first always try to merge fact-tables (concatenating, joining, mapping) instead of linking them in any way.

             

            - Marcus