Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Please find the ttachment of the QVW file .
I have a filed called filter ... and i am going to use it as filter but i want the sorting order like below
18.1
18.2
18.2
18.4
18.5
18.6
18.7
........ and so on ..Currently everything is combining very difficult to find the proper order
Please suggest some way
Thaks
Hi John,
Please try below way it may help you
Data:
Load * Inline [
Data
18.1
18.2
18.2
18.4
18.5
18.6
18.7];
Load
mid(Data,4) as Sortnumber
Resident Data;
Exit Script;
Thanks,
Arvind Patil
Not sure I understand... your field contains more than just those numbers... how would you want the overall sort to look like?
Hi sunny
Yes it has numbers as well as text .
But I want to display first ..
18.1
8.2
.
.
.and so on and then the text ..
Thanks
marcowedel's solution is working.
Load Filter,Text(Filter) as Filter_Text inline [
Filter
18.06
18.05
18.04
18.6
18.5
18.4
DAILY_OLL_CERTD_0508
DAILY_OLL_CERTD_0520
DAILY_OLL_CERTD_0530
DAILY_OLL_PKGE_0514
DAILY_OLL_CERTD_0524
DAILY_OLL_CERTD_0527
DAILY_OLL_CERTD_0507
DAILY_OLL_CERTC_0604
DAILY_OLL_CERTD_0604
DAILY_OLL_CERTC_0603
DAILY_OLL_CERTC_0605
DAILY_OLL_CERTD_0506
DAILY_OLL_CERTC_0607
DAILY_OLL_PKGE_0507
DAILY_OLL_PKGE_0508
DAILY_OLL_CERTD_0607
DAILY_OLL_CERTC_0524
DAILY_OLL_PKGE_0509
DAILY_OLL_PKGE_0513
DAILY_OLL_PKGE_0510
DAILY_OLL_PKGE_0506
DAILY_OLL_PKGE_0429
DAILY_OLL_PKGE_0503
DAILY_OLL_P220_0523
DAILY_OLL_PKGE_0430
DAILY_OLL_PKGE_0502
DAILY_OLL_PKGE_0501
18.3.05
18.6.2
Adhoc_03_WPIL_CERT
18.6.1
18.6_Sanity
1805_PUT14
DAILY_OLL_CERTC_0508
18.06.01
18.5.1
18.5.5
18.4.2
18.5.1_Trial
18.5.4
18.5.2
1805_CERT_PUT14
Adhoc_PUT14_Mano
Adhoc_03_WPIL_TSTS
Adhoc_PNR_FOP_TSTS
Adhoc_Sprint11_Newscripts
DAILY_OLL_CERTC_0507
DAILY_OLL_CERTC_0506
Adhoc_CMT24012
Adhoc_ACPMXA_QDC_18MAY
Adhoc_CMT23507_SchedChange
Adhoc_ACPMXA_QDC_15MAY
Adhoc_ACPMXA_QDC_22MAY
Adhoc_ACPMXA_QDC_23MAY
Adhoc_ACPMXA_QDC_22MAYGDS
DAILY_OLL_CERTD_0603
DAILY_OLL_TSTSB_0508
DAILY_OLL_TSTSB_0515
DAILY_OLL_TSTSB_0506
DAILY_OLL_TSTSB_0509
DAILY_OLL_TSTSB_0514
DAILY_OLL_TSTSB_0510
DAILY_OLL_TSTSA_0527
DAILY_OLL_TSTSB_0503
DAILY_OLL_TSTSA_0530
DAILY_OLL_TSTSA_0607
DAILY_OLL_TSTSA_0529
DAILY_OLL_TSTSA_0531
DAILY_OLL_TSTSA_0606
DAILY_OLL_TSTSA_0603
DAILY_OLL_TSTSA_0604
DAILY_OLL_TSTSB_0513
LATAM_18.5_FALLBACKSEG_CERT
DAILY_OLL_TSTSB_0520
LATAM_18.5_FALLBACKSEG
LATAM_Refactoring
18.4.3
std_acs
std_airlines
LATAM_18.5_Adhoc
DAILY_OLL_TSTSB_0528
DAILY_OLL_TSTSB_0605
DAILY_OLL_TSTSB_0522
DAILY_OLL_TSTSB_0530
DAILY_OLL_TSTSB_0603
DAILY_OLL_TSTSB_0531
DAILY_OLL_PKGE_0607
DAILY_OLL_PKGE_0528
DAILY_OLL_PKGE_0604
DAILY_OLL_PKGE_0527
DAILY_OLL_PKGE_0529
DAILY_OLL_PKGE_0603
DAILY_OLL_PKGE_0530
DAILY_OLL_PKGE_0531
DAILY_OLL_TSTSA_0523
DAILY_OLL_PKGE_0517
DAILY_OLL_PKGE_0523
DAILY_OLL_PKGE_0516
DAILY_OLL_PKGE_0520
DAILY_OLL_PKGE_0522
DAILY_OLL_PKGE_0521
DAILY_OLL_PKGE_0524
DAILY_OLL_TSTSA_0513
DAILY_OLL_PKGE_0605
DAILY_OLL_TSTSA_0510
DAILY_OLL_TSTSA_0514
DAILY_OLL_TSTSA_0520
DAILY_OLL_TSTSA_0515
DAILY_OLL_TSTSA_0516
DAILY_OLL_TSTSA_0509
DAILY_OLL_PKGE_0515
DAILY_OLL_TSTSA_0508
DAILY_OLL_PKGE_0606
DAILY_OLL_TSTSA_0502
DAILY_OLL_TSTSA_0506
DAILY_OLL_TSTSA_0503
];