Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
How to write a where clause with specific order list for that particular field? For example
Load * Country , State
From 'path......'
where Country = 'USA' ,'UK'
and I want a specific order of those states associated with that Country. Is this possible to get the desired result?
Hi
if you want to set a specific load order for your table to determine the sort order , all you have to do is use the INLINE LOAD before you are loading your table fields in any other table LOAD.
So that in a crosstable object the sort order will be respected :
load * inline
[Country , State
USA , Californie
USA , Nebraska
USA, Oregon
UK, Lancashire
UK, Kent
..... ] ;
Hi
if you want to set a specific load order for your table to determine the sort order , all you have to do is use the INLINE LOAD before you are loading your table fields in any other table LOAD.
So that in a crosstable object the sort order will be respected :
load * inline
[Country , State
USA , Californie
USA , Nebraska
USA, Oregon
UK, Lancashire
UK, Kent
..... ] ;