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

[Anonymous]

thanks

[Anonymous]

if I want to add all fields in chart dimension but hide those fields which are blank how we can do that

[Anonymous]

can we customize the sequence that whatever the data entry, it always come in the order  of data enriched_1,Enriched_2,Enriched_3