Grouping

[smilingjohn]

Hi IAM trying to give a new field name to this , but this script is howing wrong

Can someone suggest me the right of wrtiing this

if(match(Severity ='1 - Critical','Severity 1')and

           if(Match( Severity ='2 - High','Severity 2' ) and ,

                 if(match( Severity ='3 - Medium','Severity 3')) as Seveity,  

Thanks

[arvind_patil · Accepted solution]

Hi John,

Please find below code it may help you:

if(wildmatch(Severity ,'1 - Critical'),'Severity 1',

           if(wildmatch( Severity ,'2 - High'),'Severity 2' ,

                 if(wildmatch( Severity ,'3 - Medium'),'Severity 3'))) as Seveity

Thanks

Arvind Patil

[smilingjohn]

Thanks arvind ,

This works i also wanted to knowhow do we achieve this .

Cureently i have a field by Name  Dept , under it i have New.Old and Brand ...Now i want to show it horizontally in a startight table , then how do i write the script for this ?

Actaul :

DEPT"

New

Old

Brand

expected : New  Old   Brand

Thanks

[effinty2112]

Hi John,

This seems a simpler way to write this:

'Severity ' & Match(Severity,'1 - Critical','2 - High','3 - Medium')

or

'Severity ' & left(Severity,1)

Cheers

Andrew

[smilingjohn]

Do we need to do this at the script level ?

[effinty2112]

Hi John,

No - use it in the interface it you want.

Cheers

Andrew

[smilingjohn]

hi Andrew

Sorry its not working

I want the horizontal representaion for DEPT ?

Cureently i have a field by Name  Dept , under it i have New.Old and Brand ...Now i want to show it horizontally in a startight table , then how do i write the script for this ?

Actaul :

DEPT"

New

Old

Brand

expected : New  Old   Brand

[arvind_patil]

Please mark It.

Thanks,

Arvind Patil

[arvind_patil]

HI John,

With the help of Set analysis you can achieve this.

Thanks,

Arvind Patil