topic Re: Slowly Changing Dimension Question in QlikView

Slowly Changing Dimension Question

Thu, 23 Oct 2014 10:12:12 GMT

i have seen examples of how to do a SCD,

but how about if i have a third table which i have to join, how can i Implement this into my Script? What i need is basically the ProjectHdrName for every employee, and after that create the SCD.

have checked the web, but its hard to find any solutions.

Load ProjectHdr

ID,

ProjectHdrName

from ProjectHdr.qvd

Load TimeReport

DateKey

from TimeReport.qvd

Load Employee

EmployeeID,

Department,

Name,

StartDate,

EndDate

from excel file

Re: Slowly Changing Dimension Question

Thu, 23 Oct 2014 10:49:09 GMT

Hi,

Using of intervalmatch() you can develop the SCD.

SRC:

Load TimeReport

DateKey

from TimeReport.qvd

Emp:

Load Employee

EmployeeID,

Department,

Name,

StartDate,

EndDate

from excel file.

SCD:

Intrvalmatch(Datekey) load StartDate,EndDate resident Emp;

Re: Slowly Changing Dimension Question

Fri, 24 Oct 2014 07:53:29 GMT

Hi Rakesh, thx for answer.

After i apply the intervalmatch code, i cant load my Employee table, let me upload my script and u will see