DSXchange

You mean to say you are trying to read Hashed file using UV stage in an order?

kumar_s wrote:You mean to say you are trying to read Hashed file using UV stage in an order? ...

nop... i'm using the select tab -> output tab in the stage, to define the sort order...
but i donn't how to define the ascending o descending order...

In Sort stage, you need to give the column name on which you going to sort.
Col1 a or Col1 ASC etc.

If you are using a Hashed File stage to extract data from a hashed file - and it won't extract data from anywhere else - then on the Selection tab there are two fields.

Put your selection criteria in the top field Put your sorting criteria in the bottom, "other clauses" field Note that column names are case sensitive.

To sort in descending order, replace with in either case.

And don't forget that you only get access to the Selection tab for hashed fields that were created in an account. Or ones you've explicitly created a VOC record for.

<Thinks>
What happens if you specify it as being in an account, edit the Selection tab, then switch it to a pathed hashed file?
</Thinks>

<Thinks>
Further research is clearly required.
</Thinks>

<Thinks>
Cheater, cheater, pumpkin eater.
</Thinks>

Methinks you'd be exploiting a GUI flaw to achieve the sorting using the BY DSND without using the Account based option. There's no guarantee this functionality would be supported in the future when they change the way the GUI works. They could go either way with it.

Well, someone out there has version 8.0. If "they" were going to change the way the GUI works, version 8.0 is the most likely candidate. Anyone (who has version 8.0, of course) want to test it?

Its better to 'shout out' as a new post so that 8.0 folks can see post headings and respond. IMHO.