This discussion is archived
11 Replies Latest reply: Nov 14, 2012 2:35 AM by 973915 RSS

EXPERTS PLEASE HELP ME IN CASE STATEMENT

973915 Newbie
Currently Being Moderated
hi,

The following is the table structure that i have in the backend

cntry role name
usa ss rambo
usa ss java
usa lsm jj
usa lsm kk
usa ps ll

when i use the below case statements in two different column formulas
case when role='ss' then name end
case when role='ps' then name end

i get


CNTRY (CASEWHENROLE='SS'THENNAMEEND) (CASEWHENROLE='PS'THENNAMEEND)
USA rambo
USA
USA
USA ll
USA java



But what i need is
CNTRY (CASEWHENROLE='SS'THENNAMEEND) (CASEWHENROLE='PS'THENNAMEEND)
USA rambo ll
USA java


Can some one help me??

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points