Order By multiple dimensions

[Simon_BI]

Hi Friends,

I have input data like below. 

And i wish to have the desired output to load the data order by product and meanwhile the product with Exception "Y" is loaded firstly. The desired output can be found as below.

Attached QVW file you can use to work with. Appreciate if someone can help me here ?

Input data:

Product, DC_NO, STO_NO, DC_QTY, STO Needs, Exception
00169560, DCGACN, 001, 200, 8, N
30234229, DCGAPAU, 003, 20, 10, N
30234229, DCGAPAU, 004, 20, 10, N
00169560, DCGACN, 002, 200, 8, N
00169560, DCGACN, 020, 200, 8, N
00169560, DCGACN, 021, 200, 16, N
00169560, DCGACN, 022, 200, 16, Y
60185269, DCGACN, 028, 20, 24, N
00169560, DCGACN, 023, 200, 8, N
00169560, DCGACN, 024, 200, 8, Y
00169560, DCGACN, 025, 200, 8, N
00169560, DCGACN, 026, 200, 8, N
30234229, DCGAPAU, 005, 20, 10, N
00169560, DCGACN, 027, 200, 16, N
00169560, DCGACN, 028, 200, 24, N
30234229, DCGAPAU, 001, 20, 10, N
30234229, DCGAPAU, 002, 20, 10, N
30234229, DCGAPAU, 007, 20, 10, N
30234229, DCGAPAU, 008, 20, 10, Y
30234229, DCGAPAU, 010, 20, 10, Y
60185269, DCGACN, 027, 20, 16, Y
30234229, DCGAPAU, 006, 20, 10, N
30234229, DCGAPAU, 009, 20, 10, Y

Output:

00169560	DCGACN	022	200	16	Y
00169560	DCGACN	024	200	8	Y
00169560	DCGACN	001	200	8	N
00169560	DCGACN	002	200	8	N
00169560	DCGACN	020	200	8	N
00169560	DCGACN	021	200	16	N
00169560	DCGACN	023	200	8	N
00169560	DCGACN	025	200	8	N
00169560	DCGACN	026	200	8	N
00169560	DCGACN	027	200	16	N
00169560	DCGACN	028	200	24	N
30234229	DCGAPAU	009	20	10	Y
30234229	DCGAPAU	008	20	10	Y
30234229	DCGAPAU	010	20	10	Y
30234229	DCGAPAU	007	20	10	N
30234229	DCGAPAU	001	20	10	N
30234229	DCGAPAU	002	20	10	N
30234229	DCGAPAU	003	20	10	N
30234229	DCGAPAU	004	20	10	N
30234229	DCGAPAU	005	20	10	N
30234229	DCGAPAU	006	20	10	N
60185269	DCGACN	027	20	16	Y
60185269	DCGACN	028	20	24	N

[tresesco · Accepted solution]

Try like:

Order By Product asc, Exception desc, STO_NO asc;

[Simon_BI]

Hi Tresesco,

I tried your solution in the attached QVW file. But it doesn't work.

The output is not as i expect.

[tresesco]

Hi Simon,

If you want to see the actual data in which order it was loaded, you can go to the data model and preview the data or in table box, you have to sort it properly i.e. by 'Load Order' .

[Simon_BI]

Hi Treseco,

Yes, you are right. The back end table is in correct sequence and by sorting properly i get what i want now.

Thanks for your help.