How can I implement SCD w/ only 1 table as source?

[#1]

Hi,

I'll attach a sample excel file having records below,

Employee ID	Employee Name	Gender	Status	Date Hired
E-2012-0001	Zac Efron	Male	Single	1/14/2012
E-2012-0002	Selena Gomez	Female	Single	1/15/2012
E-2012-0003	Channing Tatum	Male	Single	2/15/2012
E-2012-0004	Amanda Seigfred	Female	Single	3/2/2012
E-2012-0005	Beyonce Knowles	Female	Married	3/3/2012
E-2012-0006	JoJo	Female	Single	3/5/2012
E-2012-0007	Jesse McCartney	Male	Single	4/2/2012
E-2012-0008	Mariah Carey	Female	Married	4/2/2012
E-2012-0009	Brian McKnight	Male	Married	4/2/2012

That is the only table, but how can I know, if one of the employees changes the STATUS from SINGLE to MARRIED?

How can I track changes or apply the SLOWLY CHANGING DIMENSION?

Please help asap. I need this to track as of dates reports.

==================================================================

Say for example,

As of June 6, 2012 Zac Erfron is Single, but as of Aug 1, 2012 he's Married. reports like that!

==================================================================

Best Regards,

Bill

[#2]

Hi,

I checked your sample excel. There's no status date and no one listed there changes status.

you should included the date they change status.

then you can use intervalmatch() function.

See qlikview help on how to use the said function.

Regards,

Alex

[#3]

Hi Alexis,

Is there a way to have that history on my own? Coz when we have to compare it to reality, changes happen w/o any record listing.

Anyway, I've got solution for that! Thanks for the help.

[#4]

post the solution