Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist
Specialist

Time Stamp in Slow Changing dimension

Hi Team,

I have requirement like slow changing dimension.

Like:

I have a table with 2 fields.

EmployeID, DepartmentName.

1,IT

2,Accounts

After few days the department has been changed for  EmployeID=2  from Accounts to Production.Like below 

EmployeID, DepartmentName.

1,IT

2,Production

 

I have to keep the track of both old and new department for employee id.

Please let me know how can I generate the timestamp when ever department for employee changes form old to new.

 

 

Thanks,

 

Narender

 

 

 

 

 

 

Labels (1)
2 Replies
Highlighted
Specialist
Specialist

Re: Time Stamp in Slow Changing dimension

Any one have idea?

 

 

Thanks

 

Narender

Highlighted
Digital Support
Digital Support

Re: Time Stamp in Slow Changing dimension

Not sure it is really going to help, but best I have for you, hopefully will give you some ideas:

https://community.qlik.com/t5/Qlik-Design-Blog/Slowly-Changing-Dimensions/ba-p/1464187

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.