LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: mwillett

Hi there,

When I use the Sort Node and select Unique, I understand that I will get a unique record for what I sort on.

Assuming there are many potential records, which was does Lavastorm select to present (the last one in the sort order, the first one in the sort order or something random), or is this an option I can configure for?

Regards,
Mike

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: rboccuzzi

It is unspecified, generally the most efficient internal method, so "random" to the user. If you want to do it in a specified manner, you should use Agg or AggEx to force an order and drop the ones you want. Sort is useful to enforce unique only when it really doesn't matter which one you choose, and you do need them sorted as well, so a nice short cut in those circumstances only.

Cheers
Rich

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: mwillett

Thanks Rich, makes sense - I was hoping for a short cut without the Agg or AggEx but that's fine.

Mike