Sorting Issue

[Anonymous]

I have a table ,I need the data list box is will appear in the same sequence at in load script,

Table1:
LOAD * INLINE [
id, data
Data_1, prim
Data_2, second
Data_3
Data_4
Data_5
Data_6
Data_7, business personal
Data_8, business social
Data_9, business third
Data_10, theature
Data_11
Data_12, plan
Data_13
Data_14, path
Data_15, path time
Data_16, path colr
Data_17, ontime
Data_18
Data_19
Data_20, comment
Data_21, ontime sec
Data_22, theee
Data_23
Data_24
Data_27
Data_28
Data_29
Data_30

];

Text box having Concat(DISTINCT data ,'|')  expression should concat the  field value in the same order as present in load script

Desired Output:-

Data_new

prim
second

business personal
business social
business third
theature
plan
path
path time
path colr
ontime
comment
ontime sec
theee

[Digvijay_Singh]

Just create one new field using Recno() and use that in concat as third parameter, like this -

Concat(DISTINCT data ,'|',RecNo)

[#3]

Hi, Shweta

Go into List Box Properties, click on Sort tab then check Load Order as Original. You desired output will be like following.

[antoniotiman · Accepted solution]

Hi,

see Attachment

Regards,

Antonio

[maxgro]

add a new id2 to the script

LOAD *, rowno() as id2 INLINE [

id, data

Data_1, prim

Data_2, second

and use id2 to sort the concat

=Concat(if(len(trim(data))>0, data), '|', id2)

[Anil_Babu_Samineni]

Here, you go

=Concat(if(Len(data)>0, data), '|', ID2)

[Anonymous]

which one is best recno() or rowno

[Anonymous]

can we implement the same in listbox without checking load order

[maxgro]

there isn't a best fro your question

RecNo or RowNo?

[antoniotiman]

See difference

LOAD *,RowNo() as Rowno,RecNo() as Recno INLINE [
id, data
Data_1, prim
Data_2, second
Data_3
Data_4
Data_5
Data_6
Data_7, business personal
Data_8, business social
Data_9, business third
Data_10, theature
Data_11
Data_12, plan
Data_13
Data_14, path
Data_15, path time
Data_16, path colr
Data_17, ontime
Data_18
Data_19
Data_20, comment
Data_21, ontime sec
Data_22, theee
Data_23
Data_24
Data_27
Data_28
Data_29
Data_30
] Where SubField(id,'_',-1) > 15;