I have a filed "A" with some 100 values.
I have to assign some group to a particular value and rest of it should be in "NA" group.
The code used is :-
Now i want the rest of the values to be shown in "NA"..... how do i do it?
I tried :-
IT DOES NOT WORK.
The below statement should works :
) as Group
I think it's a opening and closing parenthesis problem.
Tried ur solution but dsnt work.
The data type is huge clob at database level. The data consists of different names in upper /lower case as well as 1-2 page of mails.
so we are using wildmatch and '*SARANG*' to get the required result.
Also there may be a possibility that value = 'SARANG' may be present in mails also.
So i want to assign values that consits of only 'SARANG' in group 1 and rest of the emails in 'NA'.
Appreciate your help.
Is it possible for you to post some example.
In this case you should try the match() function instead of the wildmatch().
'NA', 'Group 1', 'Group 2') as Group
Hope this helps you.