Sort Hash Files

kumar_s · Post by **kumar_s** » Wed Mar 14, 2007 5:02 pm

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

ztavoz · Post by **ztavoz** » Wed Mar 14, 2007 5:07 pm

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...

kumar_s · Post by **kumar_s** » Wed Mar 14, 2007 5:13 pm

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

ray.wurlod · Post by **ray.wurlod** » Wed Mar 14, 2007 6:13 pm

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

Code: Select all

Key > 0

Put your sorting criteria in the bottom, "other clauses" field

Code: Select all

BY Col1 BY col2

Note that column names are case sensitive.

To sort in descending order, replace

Code: Select all

BY

with

Code: Select all

BY.DSND

in either case.

Code: Select all

BY.DSND Col1 BY.DSND Col2

chulett · Post by **chulett** » Wed Mar 14, 2007 6:43 pm

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.

ray.wurlod · Post by **ray.wurlod** » Wed Mar 14, 2007 6:55 pm

<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>

chulett · Post by **chulett** » Wed Mar 14, 2007 7:40 pm

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

kcbland · Post by **kcbland** » Wed Mar 14, 2007 7:47 pm

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.

ray.wurlod · Post by **ray.wurlod** » Wed Mar 14, 2007 10:51 pm

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?

DSguru2B · Post by **DSguru2B** » Thu Mar 15, 2007 6:32 am

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