Help with sort order

[hopkinsc]

Hi all,

I am having trouble getting a sort order correct to a clients needs.

I have the following sort orders in the script.

LOAD * INLINE[
Bill_Class_Model,Sort_Order1
U,1
A,2
M,3
];
LOAD * INLINE[
Account_Det_ID_Model,Sort_Order2
DU,1
CU,2
CM,3

DM,4
];

What they want is if Bill_Class_Model = M then Sort_Order2 needs to be sorted in descending order otherwise sort in ascending order.

Can anyone help please?

[jonathandienst]

Sorry, my mistake. Should be

LOAD Dual(Bill_Class_Model, Sort_Order1) As Bill_Class_Model INLINE

and

LOAD Dual(Account_Det_ID_Model, Sort_Order2) As Account_Det_ID_Model INLINE

Jonathan

[hopkinsc]

Thanks Jonathan, that loaded sucessfully but it didn't give what i was looking for.. see attachment.