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
Data Transformation
Moderators: chulett, rschirm, roy
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?
Bestest!
John Miceli
System Specialist, MCP, MCDBA
Berkley Technology Services
"Good Morning. This is God. I will be handling all your problems today. I will not need your help. So have a great day!"
John Miceli
System Specialist, MCP, MCDBA
Berkley Technology Services
"Good Morning. This is God. I will be handling all your problems today. I will not need your help. So have a great day!"