Script

[smilingjohn]

Hi All, 

I am trying to create a group by bucketing certain condition from 3  fields  in the script , this reloads but dont show any output . My script is as below . Can someone please help me achiving this ?

Thanks in Advance.

[avinashelite]

Try like this 

If(match(Dept,'A','X','Y','Z') , if(Match(Status,'Passed','Success','Processed'),'Scanned',
if(Match(Status,'Failed'),'Rejected','Total'))) as Category ,

[smilingjohn]

Hi Avinash this is not working 

[smilingjohn]

Hi ALl, 

This is my below script which i am trying to group  this script reload but it dont show in output . is there way to habdle this witout making concatenation ?

[smilingjohn]

Hi Community any help on my post?

[QFabian]

hi, in this particular case,  try with nested if, instead of separated if as i can see.

[smilingjohn]

Thanks for the reply @QFabian ,

Can you please provide me the example how do i use nested if in this perticular issue ?

Thanks 

[QFabian]

did you check the atached image in my previous reply?

Basically, as i can see, you do an if, then another, but you should do as follow :

if( A=1, action1, if (A=2, action2, if(....... and so on.

[smilingjohn]

I saw you image but i dont understand what are you trying to say .

Thanks 

[QFabian]

Checking again, you already have nested if, so, i think you should probably create each wilmatch statement as a separate field, just for seeing if the values are ok for the total ifs workflow validations.

example :