Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

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:

  

myRecordingmyRecordingType
No RecordingNO
No RecordingNO
Recording is GoodYes
Recording is excellentYes
Recording OKYes
No InformationNot Appliciable
No InformationNot 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!

1 Solution

Accepted Solutions
sunny_talwar

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

View solution in original post

2 Replies
sunny_talwar

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
Not applicable
Author

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,