Sequence

[#1]

Hi Experts,

I have Status field which consists of A,B,C,D. But i have a scenario where i have to show Status has in sequence like C,B,A,D. How to achieve this?

Thanks in Advance!!

[oknotsen]

Create an inline table at the start of your script for only that field in which you put the values in the order you want to have them. You can drop this helper table again at the end of your script. Next, sort the List Box on Load Order.

[sasikanth]

An inline table can help

Load * from Your table ;

concatenate

Load * Inline [

Status

[

status,No

C,1

B,2

A,3

D,4

]

[jagan · Accepted solution]

Hi,

Try like this

LOAD

*,

Dual(FieldName, Match(FieldName, 'C','B','A','D') AS FieldName_New

FROM DataSource;

Now in chart -> Sort -> Select Numeric

Regards,

jagan.