I have a job that transforms data and assigns a serial number to it.
At the end I want all the data to be sorted based on the serial number, but I dont want the see the serial number. DAtaStage works well if the serial number is pulled from the Sorter stage to the Output SF stage, but the data is not sorted if the serial number is not pulled into the Output. Please advise.
Sorting not working
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 43
- Joined: Thu May 29, 2008 8:41 pm
Re: Sorting not working
Use copy stage and pass all columns but serial number. Thanks.
datastagenewbie wrote:I have a job that transforms data and assigns a serial number to it.
At the end I want all the data to be sorted based on the serial number, but I dont want the see the serial number. DAtaStage works well if the serial number is pulled from the Sorter stage to the Output SF stage, but the data is not sorted if the serial number is not pulled into the Output. Please advise.
-
- Participant
- Posts: 64
- Joined: Tue Sep 23, 2008 9:54 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 64
- Joined: Tue Sep 23, 2008 9:54 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Perhaps you have RCP enabled on the transform stage output, thus implicitly passing the column on.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 64
- Joined: Tue Sep 23, 2008 9:54 am