Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to do simple Slowly Changing Dimension?

Hi,

In my client, it was being requested to the slowly changing dimension, because they will only updathe the excel file once there's a change to any of the records, specifically to its numeric value.

Say for example:

As of 4/1/2012

Item No.Item DescriptionAgreed Cover
AApple3
BBlackberry2
CChico3

And as of 6/4/2012

Item No.Item DescriptionAgreed Cover
AApple2.5
BBlackberry2
CChico3

As of 8/1/2012

Item No.Item DescriptionAgreed Cover
AApple3
BBlackberry2.6
CChico2

Note that, this is only one file (excel file)... And excel file will only be overwritten once there's change.

Please help me on this. Your help is much appreciated.

Thanks,

Bill

5 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Dear Bill,

     What do you want to achieve.

     Do you want to keep the old data with new changed records?

     Or you want to only keep new records?

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Not applicable
Author

Hi Kaushik,

There will be traces, when did the data change its value. So the old must be keep so that I may have historical data.

Thanks,

Bill

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

     See one way is you put the Update Date as one of the column, which will be updated once the data is updated.

     and then you can use the incremental load logic to get only the changed records.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Not applicable
Author

How to do incremental load logic?

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

     Incremental logic means, you load only those data or records which are updated.

     Have a look at the link below for more info on Incremental logic.

     http://community.qlik.com/docs/DOC-1870

Regards,

Kaushik Solanki    

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!