How to order values ​​in a custom order. I would like to put the following values ​​in this order: 1. “Remuneration” 2. “Employer contribution”

[Phara]

I would like to put the following values ​​in this order:
1. “Remuneration”
2. “Cotisation de l'employeur”

Also, I'd like the "Totaux" lign which is the total lign to be at the end and not at the beginning

Thank you

[Chanty4u]

Try this 

Mapping_Table:

MAPPING LOAD * INLINE [

    Value, SortOrder

    Remuneration, 1

    Cotisation de l'employeur, 2

    Totaux,3

];

Data:

LOAD 

    Field1,

    Field2,

    Field3

RESIDENT YourData;

FinalData:

LOAD

    *,

    ApplyMap('Mapping_Table', Field1) as SortOrder

RESIDENT Data

ORDER BY SortOrder;

[Anil_Babu_Samineni]

Please try like this

#1, You can play around sorting

#2, That is default, in case if that force by business, there might be workaround with Island table.