How to have a field reference a different word

[Ehumphree]

Hi Everyone,

Sorry new to Qlik and still getting myhead around it as it is a little different to other platforms i have used. I have field i am trying to reflect a word as a response instead of a letter. 

i.e. if [smoking pathway] = 'y' then Yes, ='n' then 'No and 'p" = Partial 

Any help anyone can give will be greatly appreciated. 

[Vegar]

Try this

pick(match([pathway] , 'y' , 'n','p'),'Yes', 'No' ,'Partial')

You could also do an applymap() to solve this. 

[Ehumphree]

Is it best to put this in the load script or is there somewhere else i should be putting this.

[Vegar]

Yes I would have put this in my load script.