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.
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.
