need help on this

[bhargav_dd]

hi friends,
I have I/p like,
empno sal
ravi 1000
raju 2000
srinu 3000
rao 500

i want o/p like
empno sal
ravi 1000
ravi 1000
raju 2000
raju 2000
raju 2000
raju 2000
srinu 3000
srinu 3000
srinu 3000
srinu 3000
srinu 3000
srinu 3000
rao 500
can any one explain how can i achieve this?

[zulfi123786]

Could you elaborate what is the rule that defines how many times a row should be duplicated?

[chulett]

Seriously, how can you expect anyone to know your secret rules on how to generate that output? It's nice that you posted what you need it to look like but you also need to explain in words the business rules / methodology you've been given to get there - don't make people guess or have to puzzle it out.

[ray.wurlod]

I think I know what the rule is, but will await the original poster's response.

A meaningful subject line would have been good, too.

[chulett]

I would change it if I had any idea what to put there.

[stuartjvnorton]

InfoSphere has a MindReader stage, but it comes at an extra charge, IIRC.

[ds@tcs]

post clear query

[ray.wurlod]

This has a fairly easy resolution in 8.5 (if my guess about the requirement is correct) but is more difficult - but not impossible - in earlier versions.

[bhargav_dd]

i have got the desired output but for your information i am not taking about any business rules i just gave an example to my requirement so that it can be easily understood

[chulett]

i am not taking about any business rules i just gave an example to my requirement so that it can be easily understood

We know, that's the problem - and from the responses here you can see it didn't work... well, except perhaps for Ray. So are you saying you've already solved this problem? If you still need help, as requested, clarify the rules needed to get from A to B.