12-26-2013 09:28 PM
Is possible, using only transformations in DI Studio (without using programming), get the previous record of a data set and implement the logic below?
I need to calculate a new column that uses the value from the previous record.
1 a a
1 b a-b
1 c a-b-c
2 d d
3 e e
3 f e-f
12-28-2013 12:01 PM
From your sample (which seems abit inconsistent), I would say no.
If this is a common task, you could package your logic in a User Written Transformation so it could be reused.
But can I question the purpose for this logic? From the little information you give, the calculation doesn't look like anything that needs to be stored in a Data Warehouse process, rather a customized report. Please tell us more about the business requirement for this calculation.
Need further help from the community? Please ask a new question.