Sort order in pivot table

[dia2021]

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?

[brunobertels · Accepted solution]

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

..... ] ;