How to Split one field into whole new field with If condition

[Anonymous]

Hello Guys,

I want to split Status Field into something as mentioned below :-

I need to put If condition and create a new field such as

If (Status'Anticipated', Status='Quote Submitted' , Status='No Quote') = Progress

If (Status='Lost', Status='WIN in Flow 3', Status='Canceled') = Win    as [Status Type]

I want to club this 2 If condition and create new field [Status Type]

Could you please tell me how do we do this ?

Thanks,

ravi

[shraddha_g]

If (Wildmatch(Status,'Anticipated', 'Quote Submitted' ,'No Quote'),'Progress',

If (Wildmatch(Status,'Lost', 'WIN in Flow 3', 'Canceled') ,'Win'  ))  as [Status Type]

[mdmukramali]

Hi,

you can use match function,

If(Match(Status,'Anticipated','Quote Submitted','No Quote'),'Progress',

     if(Match(Status,Lost','WIN in Flow 3','Canceled'),'WIN')) as [Status Type]

[arvind_patil]

Hi Ravi,

It may be like this:

If (Wildmatch(Status,'Anticipated', 'Quote Submitted' , 'No Quote') , 'Progress'

      If (Wildmatch(Status,'Lost', WIN in Flow 3', 'Canceled') ,'Win'))            as [Status Type]

Thanks,

Arvind Patil

[Anonymous]

Thanks a lot It worked

[Anonymous]

Thanks arvind_patil , mdmukramali  It worked

[Anonymous]

Guys ,

Now if i want to use only the  Progress option . i am doing something like this :-

FROM [Project.qvd]

(qvd)

Where ( [Status Type]='Progress');

but if i do this it says [Status Type] not found , So how do i use only 'Progress' status ?

Thanks,

ravi

[mdmukramali · Accepted solution]

Hi,

After Reloading the Table [Status Type] willbe created so you can't use [Status Type] in the same Table where condition.

you can try something like this.

FROM [Project.qvd]

(qvd)

Where Match(Status,'Anticipated','Quote Submitted','No Quote');

[Anonymous]

Thank you mdmukramali