Hi,
Hope below code helps community friends in achieving the slowly changing dimensions without the use of IntervalMatch(). I have a Transaction table with Week and Value fields and I have another table which holds the Rank of a Value in a particular week. To implement this without using IntervalMatch() we can use below code.
TransactionTable:
Load * Inline [
Week ,Value
10 ,1
10 ,2
10 ,3
10 ,4
11 ,1
11 ,2
11 ,3
11 ,4
];
LEFT JOIN(TransactionTable)
LOAD
Week,
Rank,
Desc,
Start + Iterno() -1 AS Value
WHILE Start + Iterno() -1 < End;
Load *
Inline [
Week ,Start ,End ,Rank ,Desc
10 ,0 ,2 ,1 ,0-2
10 ,2 ,3 ,2 ,2-3
10 ,3 ,6 ,3 ,3-6
10 ,6 ,8 ,4 ,6-8
11 ,0 ,3 ,1 ,0-3
11 ,3 ,4 ,2 ,3-4
11 ,4 ,7 ,3 ,4-7
11 ,7 ,8 ,4 ,7-8
];
Regards,
Jagan.
