Forum Discussion
Help Converting SCD0 to SCD2
Hello! I have been using an attribute table that utilizes a slowly changing dimension type 0 model where all the data is today's values, no history. My company has now turned on tracking of historic...
As nobody has bitten yet, I continue to look into this issue.
It seems like I should be able to group the items by PropertyCode, sorted by effective date ascending, and fill down the columns contained within the group then expand the grouped data but that doesn't appear to be working. All of my missing values are null, as I saw in some research that they need to be null in order to work properly. Some other solutions I saw created a new column for each item to be filled, but I have 24 columns currently with the potential of more to be added at any given time so the solution needs to deal with n number of columns in 1 step.
Still looking for some assistance here!