Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
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
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,