DSXchange

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.

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.

After the sort.

I am going to try it. I tried, transformer, but that did not work.

A correctly-programmed Transformer stage (after the Sort stage) WILL work to drop a column.

[quote="ray.wurlod"]A correctly-programmed Transformer stage (after the Sort stage) WILL work to drop a column. ...[/quote]
hmm. I used the transformer to just drop the column. It didnot have anything else in it. Do u think something needs to be added in the transformer?

I have no idea what U (one of our members) thinks, but nothing needs to be added. Maybe something (RCP perhaps) needs to be removed.

Perhaps you have RCP enabled on the transform stage output, thus implicitly passing the column on.

[quote="ArndW"]Perhaps you have RCP enabled on the transform stage output, thus implicitly passing the column on. ...[/quote]

I used the Copy Stage and unchecked RCP. ANd it's working. Thanks for all ur help!