Hi all,
I'm new to Alteyrx designer and need some help so basically I have this test data set and I added in a new column called W_Code using a formula and then did a find and replace to find the codes HL, MTL, PARL, PBHOL, PL, PRNTL, SK, SK-Cert, SL, SP and replace them with the word Leave in the new column.
I'm just wondering how can I reorder the rows so that all the leaves are displayed one after another followed by the other codes then.
any help is much appreciated.
| Code | Description | W_Code |
| HL | Leave 1 | Leave |
| INTCOM | Projects | INTCOM |
| INTQUAL | QA Testing | INTQUAL |
| MADIS | Torque | MADIS |
| MTL | Maternity Leave | Leave |
| OPSTEAM | Dev Ops | OPSTEAM |
| OT | Overtime | OT |
| PARL | Leave 2 | Leave |
| PAYZ | Payrol System | PAYZ |
| PBHOL | Public/Bank Holiday | Leave |
| PL | Leave 3 | Leave |
| PRNTL | leave 4 | Leave |
| PRO | Proposals New Work | PRO |
| RCPS | RCPS Projects ( risk, compliance and Professional Standards) | RCPS |
| REGIN | Regulatory Inspections | REGIN |
| SK | sick Leave Un certified | Leave |
| SK-CERT | Sick Leave Certified | Leave |
| SL | Study Leave | Leave |
| SP | Speacial Leave (Breavement/Force Majure, Etc) | Leave |
