Hi, We have HCM extract which feeds data to e-text template. I have a requirement to sort the data by person number/Payroll Relationship Number. In e-text template, I am using the below criteria to do the sorting but it's not working. I did not see any option to sort the data in HCM Advanced filtration criteria as well. Please suggest or share if you have any sample e-test template with Sort function.
<LEVEL> | Employee_Details |
<SORT ASCENDING> | To_number(Person_Number) |
<POSITION> | <LENGTH> | <FORMAT> | <PAD> | <DATA> | <COMMENTS> |
<NEW RECORD> | EMPLPIM _Details |
Thank you