Specific ordering of Rows

[Inactive User]

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

[FrederikE · Accepted solution]

Hey @Inactive User,

You can just use another formula with something as simple as: 

IF W_Code='Leave'

THEN 1

ELSE 0

ENDIF

End then sort by the newly created column in the desired way. Then deselect the newly created col. again. 

[Inactive User]

Hey  @FrederikE, 

I'll give it a try and see how it goes thank you for your very fast response.