Data Transformation

ravi123 · Post by **ravi123** » Mon Oct 20, 2008 10:59 am

Hi

I need to convert data below information

input

col1, col2

st 3
et 5
ct 2

output

col1,col2
st 1
st 2
st 3
et 1
et 2
et 3
et 4
et 5
ct 1
ct 2

Can you please give me the suggestion

Thanks
Ravi

chulett · Post by **chulett** » Mon Oct 20, 2008 11:14 am

Suggest you spell out your data transformation rules rather than expect everyone to divine them from your example.

Nagaraj · Post by **Nagaraj** » Mon Oct 20, 2008 1:22 pm

You can do this by defining stage variables which will look for the change in the first column and one stage variables which will value as you have mentioned.

jdmiceli · Post by **jdmiceli** » Mon Oct 20, 2008 2:04 pm

Looking at your input, this does not seem like a data transformation as much as setting an upper limit with an assumed 1 as the starting point. As Craig pointed out, is there more to it? What are your business requirements?