Page 1 of 1
need help on this
Posted: Sat Apr 16, 2011 3:13 am
by 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?
Posted: Sat Apr 16, 2011 4:59 am
by zulfi123786
Could you elaborate what is the rule that defines how many times a row should be duplicated?
Posted: Sat Apr 16, 2011 6:53 am
by 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.
Posted: Sat Apr 16, 2011 4:17 pm
by 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.
Posted: Sat Apr 16, 2011 9:18 pm
by chulett
I would change it if I had any idea what to put there.
Posted: Sun Apr 17, 2011 7:56 pm
by stuartjvnorton
InfoSphere has a MindReader stage, but it comes at an extra charge, IIRC.
Re: need help on this
Posted: Mon Apr 18, 2011 1:49 am
by ds@tcs
post clear query
Posted: Mon Apr 18, 2011 2:02 am
by 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.
Posted: Mon Apr 18, 2011 6:32 am
by 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
Posted: Mon Apr 18, 2011 6:47 am
by chulett
bhargav_dd wrote: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.