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 |
x`
