Fact Generation in Load script

Wed, 25 Nov 2020 16:16:04 GMT

Hi Team,

I am new to the Qlikview. I have a requirement on the data model. I received below Raw data file from the business in the excel format.

I have to create dimensions and facts from this and load the data every day.

RAW DATA : Received from business
Employee ID	Employee Name	City	Date of Joining
1	Alex	USA	2014
2	Dom	UK	2015
3	Shaun	USA	2011
4	Dale	Australia	2012
5	Bill	India	2013
6	Cathy	Japan	2014

I have come up with the dimensions and facts as follows

City Dimension
City Key	City Name
1	USA
2	UK
3	USA
4	India
5	Japan
6	Australia

Year Dimension
Year Key	Year
1	2010
2	2011
3	2012
4	2013
5	2014
6	2015
7	2016

Employee Dimension
EmpKey	EmployeeID	Employee Name
1	1	Alex
2	2	Dom
3	3	Shaun
4	4	Dale
5	5	Bill
6	6	Cathy

My Question is how to create fact table as shown below in the script. Could you please let me know how to create a script to populate below fact table by using above dimension table. Thanks in advance.

Fact Table

Fact key	EmpKey	CityKey	Yearkey
1	1	1	5
2	2	2	6
3	3	1	2
4	4	6	3
5	5	4	4
6	6	5	5

Re: Fact Generation in Load script

marcus_sommer — Thu, 26 May 2016 11:59:42 GMT

You don't need to do this. In this case you could simply load the rawdata and it will work greatly then in qlikview you don't need things like to normalize the data - you will need to do rather exact the opposite.

- Marcus

topic Fact Generation in Load script in QlikView

Fact Generation in Load script

Re: Fact Generation in Load script