Stage sort filter output results??

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
Marcelo
Participant
Posts: 7
Joined: Mon Dec 22, 2003 8:14 am

Stage sort filter output results??

Post by Marcelo »

Hi,

I using the sort stage and the output result is ok.
But i want to filter the result.
I have a column with values (1, 2, 3, 4, 5, 6 and 7).
To my job, i just need the values 1 and 3.
Are in the Sort stage a function where i can filter this column?
This column is not in the Sorting key.

tks
Marcelo
Marcelo Carvalho Terhoch
Unibanco AIG Seguros & Previdência
Tecnologia - Visão Pessoas - Data Mart
Av. Eusébio Matoso, 1375 - 7.andar -Company I
55-11-3039-4432
Woth
Participant
Posts: 24
Joined: Thu Mar 18, 2004 8:18 pm

Post by Woth »

Marcelo,
I dont think you need the sort stage. Here is what I would do. I would use a copy stage ; in the partitionning tab, sort the input data as you wish, and in the output tab, drag the needed colums only.

Just a taught
Post Reply