topic Re: Inline Load Sorting in App Development

Inline Load Sorting

Karahs — Sat, 16 Nov 2024 20:18:44 GMT

Hello All,

I have the following inline table:

Dim1:
Load * Inline
[
_Dim1No,Dim1
1,DateOfBusiness
2,Month
3,Week
4,City
];

I want the same order as above in my dimension (always selected one) on selection bar.

As above image i am not getting it order. Can anyone suggest any way to sort the inline load?

Thanks

Re: Inline Load Sorting

tresB — Wed, 07 Aug 2019 07:51:08 GMT

Try loading using dual(), like:

Dim1:
Load

_Dim1No,

Dual(Dim1, _Dim1No) AS Dim1

Inline
[
_Dim1No,Dim1
1,DateOfBusiness
2,Month
3,Week
4,City
];

Re: Inline Load Sorting

Gysbert_Wassenaar — Wed, 07 Aug 2019 07:57:18 GMT

You can't get the same order in the selection bar. A filter pane has a Sorting section in its properties pane, but the selection bar cannot be changed. You could create a new field using the Dual function:

Dim1:
Load *, dual(Dim1,_Dim1No)as Dim2 Inline
[
_Dim1No,Dim1
1,DateOfBusiness
2,Month
3,Week
4,City
];

Dim2 will be a numeric field with textual 'formats' for each number. Try it and see if it works for you.

Re: Inline Load Sorting

dhasharadh — Wed, 07 Aug 2019 07:56:33 GMT

go to sorting options and uncheck A-> Z and check Load order.

Re: Inline Load Sorting

Karahs — Wed, 07 Aug 2019 08:02:27 GMT

Thanks Gysbert_Wassenaar