Inspiration on data loading into a fact table in Qlik Sense

[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_month	channel	budget
201706	online	5000
201706	direct sales	2300
201706	tele sales	1000
201706	shops	6500

Online sales: (MSSQL database) aggregated

year_month	no_of_sales
201706	4521
201705	5874
201704	5586
201703	5412

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

year_month	channel	no_of_sales
201706	direct sales	2458
201706	tele sales	857
201706	shop sales	7811
201705	direct sales	3157
201705	tele sales	1247
201705	shop sales	7436

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

[#2 · Accepted solution]

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;