Is it possible to create a new text column with "Add a calculated column" in Qlik sense?

[Anonymous]

My data source is in Oracle database and Excel sheet.

The column is as the following:

myRecording

No Recording

No Recording

Recording is Good

Recording is excellent

Recording OK

No Information

No Information

I need change the text in the myRecording column as the following:

myRecording	myRecordingType
No Recording	NO
No Recording	NO
Recording is Good	Yes
Recording is excellent	Yes
Recording OK	Yes
No Information	Not Appliciable
No Information	Not Appliciable

Is it possible to use 'Add a calculated column' in Qlik sense to get the new column 'myRecordingType'? Also, I need load the data from Oracle database and Excel file.

Any suggestion is appreciated!

[sunny_talwar · Accepted solution]

Sure you can...

LOAD myRecording,

          If(Match(myRecording, 'No Recording'), 'NO',

          If(WildMatch(myRecording, 'Recording*'), 'Yes', 'Not Applicable')) as myRecordingType

FROM ...

or you can use a mapping load to maintain a more complex list of myRecording options

[Anonymous]

Hi Sunny , thanks so much for your help!
I just figured out a solution. Your method is better than mine.
The following is my method.
Thanks again!

LOAD

    ( if ([myRecording] ='Recording is Good' or [myRecording]='Recording is excellent'or [myRecording]='Recording OK','Yes',

          if ([myRecording] ='No Recording', 'No','Not Appliciable')
        )
    ) as myRecordingType,