How to get second highest digit from array?

11 replies
36 views

Hello community,

can anyone suggest me how to get second highest number from an array.

Thanks in advance

harshitb6843Answer

Brainy

a!localVariables(
  local!array: {1,2,3,4,5,6},
  max(difference(todecimal(local!array),max(local!array)))
)

U

ujjwalr0002

Participating Frequently

Check this plugin https://community.appian.com/b/appmarket/posts/sort-utilities

index(
  sortintegerarray(
    {1,20,8,9,2},
    true()
  ),
  2,
  {}
)

sunilc0007Author

Known Participant

It shows error

The function 'sortintegerarray' is unavailable.

harshitb6843

Brainy

That is a plugin. Do not use plugin for this simple usecase.

harshitb6843Answer

Brainy

a!localVariables(
  local!array: {1,2,3,4,5,6},
  max(difference(todecimal(local!array),max(local!array)))
)

stefanhelzle0001

Brainy

Very neat approach :-)

amans0009

Participating Frequently

a!localVariables(
  local!val:{1,2,3,4,0},
  local!max1: max(local!val),
  local!ans: a!forEach(
    items: local!val,
    expression: if(fv!item=local!max1,{},fv!item)
  ),
  local!max2:max(local!ans),
  local!max2
)

Sign up

Login with SSO

Login to the community

Login with SSO