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

[avinashelite]

if your have got the answer , mark the correct and helpful answers

[MindaugasBacius]

According to your needs and issue you can make it few ways.

The first.

LOAD * INLINE [
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
]
Where Match(CLM_TYPE,'Cashless','Reimbursment')
;

The result would be like this:

The second.

LOAD AGENT_FULL_NAME
  ,POL_AGENT_CODE
  ,If(Match(CLM_TYPE,'Cashless','Reimbursment'), CLM_TYPE) as CLM_TYPE
INLINE [
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
]
;

The outcome would be like this:

If you're not going to use rows were CLM_TYPE field is null I definitely use the statement with Where clause.

Please find the attachment.

[sagarrahul]

thank u  for help and time avinash r

[susovan]

Hi sagar,

Try this.

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

[Pulkit_Thukral]

Did This helped you Sagar ?

[sagarrahul]

yes it helped .

again thanx

[Pulkit_Thukral]

Also if you can mark it helpful/correct.

Thanks