Sort order in pivot table

dia2021 — Tue, 30 Nov 2021 18:17:33 GMT

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?

Re: Sort order in pivot table

brunobertels — Fri, 23 Jul 2021 14:34:28 GMT

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

..... ] ;

topic Re: Sort order in pivot table in App Development

Sort order in pivot table

Re: Sort order in pivot table