DSXchange

hi ALL

I have src as year col i want to do each year some calculation. And each year should reset the values.

please tell me how to do this one basicaly year separation from single column and reset the values from staging var ?

Thanks in Adv

I have no idea what you are asking for. Can you provide examples - both of the source data and what the transformed output should be?

from your query i have understand one thing you want separate year from column .you can do this by using function 'YearFromDate()'.