Short

[#1]

i have a selection box where i have used category column

and value of category is like

abc

dec

xyz

ghd

hji

jky

and i want to short it like

jkl

xyz

dec

hji

abc

jky

i have tried by using inline table as category

jkl ,01

xyz,02

dec,03

hji,04

abc,05

jky,06

as no assign as column s.no

and try to short expession s,no

assending

but not getting desired result ,

is there any way to short as i need.

[CELAMBARASAN]

Load the sort order in inline before the loading the main table

then use sort by as Load Order

[MayilVahanan · Accepted solution]

Hi,

Use like this,

    = wildmatch(FieldName,'jkl','xyz','dec','hji','abc','jky') in Sort tab ->expression and give ascending

     (Or)

Load * inline

[

FieldName,Value

jkl ,01

xyz,02

dec,03

hji,04

abc,05

jky,06

];

Load * from fileName;

Hope it helps