group

[smilingjohn]

Hi ALl

Hi i have a field name called lstatus and it has many type of status in it i wanted to grupou the below mentioned status as Close and other should be as it is

if(match(Lstatus('Closed','Cannot-Re-Create','Working-As-Designed','Training','Duplicate','Obsolete','Further-Discussion-Required'),'Close',LStatus

Can someone please suggest me on this ?

[Anil_Babu_Samineni]

Here you go?

if(match(Lstatus,'Closed','Cannot-Re-Create','Working-As-Designed','Training','Duplicate','Obsolete','Further-Discussion-Required'),'Close',LStatus)

[arvind_patil]

Hi John,

Try Below one:

if(Wildmatch(Lstatus,'Closed','Cannot-Re-Create','Working-As-Designed','Training','Duplicate','Obsolete','Further-Discussion-Required'),'Close',LStatus) as FinalStatus

Thanks,

Arvind Patil

[balar025]

Try ApplyMap function.

StatusMapping:

Mapping Load * Inline

[

Status,Status1

Closed,Close

Training,Close

];

Data:

Load

LStatus,

ApplyMap('StatusMapping',LStatus,LStatus) as NewStatus;

Load * Inline

[

LStatus

Closed

Training

Open

];

[smilingjohn]

It is giving is giving me the error  for below script

if(WildMatch(Status,'New'), 'New',

        if(WildMatch(Status,'In Progress'), 'In Progress',

        if(WildMatch(Status,'Resolved'), 'Resolved',

        if(WildMatch(Status,'Test'), 'Test',

      if(WildMatch(Status,'*Blocked-*'), 'Blocked',

     if(WildMatch(Status,'Failed'), 'Failed',

      if(WildMatch(Status,'Failed'), 'Failed',

     if(WildMatch(Status,'Code Review'),'Code Review',

     if(WildMatch(Status,'SCCB'),'SCCB',

     if(WildMatch(Status,'Closed','Cannot-Re-Create','Working-As-Designed','Training','Duplicate','Obsolete','Further-Discussion-Required','Close',))))))))))as Lstatus,

[balar025]

Have you tried below script?

StatusMapping:

Mapping Load * Inline

[

Status,Status1

Closed,Close

Training,Close

];

Data:

Load

LStatus,

ApplyMap('StatusMapping',LStatus,LStatus) as NewStatus;

Load * Inline

[

LStatus

Closed

Training

Open

];

[sunny_talwar · Accepted solution]

May be this

if(WildMatch(Status,'New'), 'New',

        if(WildMatch(Status,'In Progress'), 'In Progress',

        if(WildMatch(Status,'Resolved'), 'Resolved',

        if(WildMatch(Status,'Test'), 'Test',

      if(WildMatch(Status,'*Blocked-*'), 'Blocked',

     if(WildMatch(Status,'Failed'), 'Failed',

     if(WildMatch(Status,'Code Review'),'Code Review',

     if(WildMatch(Status,'SCCB'),'SCCB',

     if(WildMatch(Status,'Closed','Cannot-Re-Create','Working-As-Designed','Training','Duplicate','Obsolete','Further-Discussion-Required'),'Close' ))))))))) as Lstatus,

[Chanty4u]

Bro just wanted to know  is it works or anything ?Sunny Talwar

instead of this if conditions can we create a inline table like   below?  

load * inline[

status,value

new, ,,,

...

,..............];

[sunny_talwar]

Are you asking me?

[balar025]

Not advisable to use long if conditions.