How to separate data

[Ehumphree]

Hi Everyone,

I am trying to split a data set that is displayed in one column into two separate columns in a table.

i.e. LW_FLAG 1 = In Time and 2 = Long Wait.

I want to be able to show these in two separate columns. 

Speciality	In Time on Wait List	Long Wait on Wait List
Category

. 

Any assistance you can provide will be greatly appreciated.

[NJC]

Hi @Ehumphree ,

Try like below in load editor 

if(LW_FLAG=1,'In Time','NA') as [In Time on Wait List],
if(LW_FLAG=2,'Long Wait','NA') as [Long Wait on Wait List]

Thanks!