Hi,

How can I sort the column values in a specific order in the load script? For instance, I have one column with Order and another column is with Order description. Where A contains 3 descriptions, B contains 4 descriptions and C contains 5  descriptions. The fields in Order table are sorted alphabetically (A,B,C) but I want the sort order as B,C,A.  Similarly, I want specific sort order for the Description table which is grouped by  Order field rather than sorted default alphabetically.

I got this  at the front end by applying  match function in set expression.

How can I do this in the Load script?

Thanks!