Hi,
Please find the requirement below For better understanding about my query i have underline the required output
source Target
custno custpre abc
1 2 1,2,3
1 3 2,5,6
2 5
3 6
How do i perform if using transformer.
Thanks in advance
Regards,
Sirish.
How to convert multiple columns into rows.
Moderators: chulett, rschirm, roy
Please look into the Pivot Enterprise stage in the Parallel Job Developer Guide and, should your needs not be met by that stage, ask again here in this thread.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Thanks for your prompt reply ANDRW but i could not meet my requirement by pivot stage i initiated my job initially by Pivot stage,i am supposed to use transformer folowed by aggregator to perform the jobArndW wrote:Please look into the Pivot Enterprise stage in the Parallel Job Developer Guide and, should your needs not be met by that stage, ask again here in this thread.
thanks in advance.
Sirishds
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
It can be done using stage variables, but I agree with Ray that unless there is a good reason not to use the pivot it should be used.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>