I have several case prefixes that I need to place in groups.
I need groupings:
Case Type | Group
G = Global
SA = TC/PC
BR = TC/PC
OR = TC/PC
MF = TC/PC
So that I have a QV field to choose either GLOBAL or TC/PC
Any help would be apprieciated.
Looks like you need this:
if([Case Type]='G', 'Global', 'TC/PC') as Group
Look at MAPPING in the Help and Ref Guide.
Hmmm... My previous post got lost for some reason.
Here is another suggestion:
Sinse you have only 2 possible values for Group field, you can use IF expression:
If([Case Type] = 'G', 'Global','TC/PC') as Group;
Retrieving data ...