choice data

[sagarrahul]

hiiii

i need a help

this my table where i have

1) AGENT_FULL_NAME

2) POL_AGENT_CODE

3) CLM_TYPE

table :

AGENT_FULL_NAME        POL_AGENT_CODE              CLM_TYPE

abc                                         200355444460                             Cashless

wer                                         200355444461                             PREAUTH

fds                                          200355444462                             Cashless

iyt                                           200355444463                             PREAUTH

tyui                                         200355444464                              PREAUTH ENHANCEMENT

nbv                                         200355444465                              Reimbursment

mkl                                         200355444466                              Reimbursment

asd                                         200355444467                              Cashless

rfv                                           200355444468                             PREAUTH

qwe                                        200355444469                             PREAUTH

qwe                                        200355444460                             Cashless

qwet                                       200355444460                             Cashless

i need all agent and its agent codes who has booked only Cashless and Reimbursment clm type .

output need :

AGENT_FULL_NAME        POL_AGENT_CODE                   CLM_TYPE

abc                                         200355444460                             Cashless

wer                                         200355444461                           

fds                                          200355444462                             Cashless

iyt                                           200355444463                            

tyui                                         200355444464                             

nbv                                         200355444465                              Reimbursment

mkl                                         200355444466                              Reimbursment

asd                                         200355444467                              Cashless

rfv                                           200355444468                            

qwe                                        200355444469                            

qwe                                        200355444460                             Cashless

qwet                                       200355444460                             Cashless

can u pls help me in this

[ajsjoshua]

Hi,

Try like this

{<CLM_TYPE = {"Cashless*", "?Reimbursment*"}

or

{<CLM_TYPE = {"*"} - {"PREAUTH*"}>}

[sagarrahul]

its not working joshua solomon

[Pulkit_Thukral]

Hi Sagar,

Try in scripting :

Load

AGENT_FULL_NAME,

POL_AGENT_CODE,

if((CLM_TYPE='Cashless' or  CLM_TYPE='Reimbursment'),CLM_TYPE,'-') as CLM_TYPE_Updated

From xyz;

OR

Load

AGENT_FULL_NAME,

POL_AGENT_CODE,

if((CLM_TYPE='Cashless' or  CLM_TYPE='Reimbursment'),CLM_TYPE,Null()) as CLM_TYPE_Updated

From xyz;

[sujeetsingh]

Sagar,

You can achieve this by using set analysis where as by if condition.  You can use if condition in dimension too.

=if(wildmatch(CLM_TYPE,'Cashless','Reimbursment' ,AGENT_FULL_NAME  )     

This will only give you those names where the CLM type is respective.

[sagarrahul]

bro can present it in script 

[sagarrahul]

thank u  for help and time pulkit thukral

[sagarrahul]

thank u  for help and time joshua solomon

[avinashelite]

In script level:

Load

AGENT_FULL_NAME,

POL_AGENT_CODE,

if((CLM_TYPE='Cashless' or  CLM_TYPE='Reimbursment'),CLM_TYPE) as CLM_TYPE_Updated

From table;

in front end

Add

Dimension: AGENT_FULL_NAME and POL_AGENT_CODE

Expression: only({<CLM_TYPE={'Cashless','Reimbursment'}>}CLM_TYPE)

[ajsjoshua]

Hi,

=if(match(CLM_TYPE,'Cashless','Reimbursment'), CLM_TYPE)