Merge a server Pivot and Hashed stages...

[chucksmith]

I would love to have an active stage that is similar to a hashed file stage with one input and one output link. This stage would not land data on disk, but would allow the incoming row to be normalized on the fly.

This would be more flexible than a pivot stage, because one incoming row could generate a variable number of outgoing rows. Additionally, it would preserve the order of data, something that is lost when writing then reading from a normalized hashed file.

[ray.wurlod]

You can always include a sorting clause on the Selection tab when reading from a Hashed File stage.

Syntax is that of the RetrieVe query language.
BY field (for ascending order)
BY.DSND field (for descending order)

You need one clause for each sorted field.
For example: BY REGION BY COUNTY BY.DSND SALES