1 Reply Latest reply: Jun 20, 2017 6:31 AM by Rima Hajou RSS

    Inspiration on data loading into a fact table in Qlik Sense

    Michael Vaisgaard

      Hi fellow data geeks,

       

      I need some inspiration on how to load data into a fact table from multiple sources. I know how to do this in Oracle, but I would like to start using Qlik Sense to do this instead.

       

      Scenario: I have multiple data sources which contains the data I need:

       

      Budgets: (Excel sheet)

      year_monthchannelbudget
      201706online5000
      201706direct sales2300
      201706tele sales1000
      201706shops6500

       

      Online sales: (MSSQL database) aggregated

      year_monthno_of_sales
      2017064521
      2017055874
      2017045586
      2017035412

       

      Direct sales, tele sales and shop sales: (Oracle database) aggregated:

      year_monthchannelno_of_sales
      201706direct sales2458
      201706tele sales857
      201706shop sales7811
      201705direct sales3157
      201705tele sales1247
      201705shop sales7436

       

      So how would I put the above into a fact table using Qlik Sense only?

        • Re: Inspiration on data loading into a fact table in Qlik Sense
          Rima Hajou

          Hello,

          Is there a link between the 3 data sources ?

          For example Online sales: (MSSQL database) is linked to Direct sales, tele sales and shop sales: (Oracle database) using no_of_sales ?



          if there is no link between the 3 tables do the following:

          Tables:

          Load

          * ,

          'Budget' as Flag

          from Budget.xlsx

           

          concatenate(Tables)

          Load

          *,

          'Online sales' as Flag

          from Online sales: (MSSQL database)


          concatenate(Tables)

          Load

          *,

          'Oracle database' as Flag

          from Direct sales, tele sales and shop sales: (Oracle database)



          In the above case, we concatenated the 3 tables into one table in qlik sense.

           

          If there is a link between MSSQL and Oracle :


          MSSSQL:

          Load

          *

          from Online sales: (MSSQL database)


          left join

          Load

          *

          from Direct sales, tele sales and shop sales: (Oracle database)


          Tables:

          Tables:

          Load

          * ,

          'Budget' as Flag

          from Budget.xlsx;


          concatenate(tables)

          Load *,

          'NotBudget' as Flag

          resident MSSSQL;