Filter values from an array which does not belongs to a group

Sameer Ul Haq over 1 year ago

Hi All,

Below is my Array.

{
    {
        Id:"A",
        Value: 123
    },
    {
        Id:"B",
        Value: 345
    },
    {
        Id:"C",
        Value: 678
    }
}

1.I want to check if list contains items with Id apart from "A" and "B".

2.Also I want to filter the items whose Id is not equal to "A" and "B".

Discussion posts and replies are publicly visible

Parents

0 tejpals0001

Certified Associate Developer

over 1 year ago

a!localVariables(
  local!array : {
    {
      Id:"A",
      Value: 123
    },
    {
      Id:"B",
      Value: 345
    },
    {
      Id:"C",
      Value: 678
    }
  },
  local!idsnotIncludedforfilter :{"A","C"},
 
 local!filteredData: remove(local!array,wherecontains(local!idsnotIncludedforfilter,touniformstring(index(local!array,"Id",{})))),
 local!filteredData
)

Reply

0 tejpals0001

Certified Associate Developer

over 1 year ago

a!localVariables(
  local!array : {
    {
      Id:"A",
      Value: 123
    },
    {
      Id:"B",
      Value: 345
    },
    {
      Id:"C",
      Value: 678
    }
  },
  local!idsnotIncludedforfilter :{"A","C"},
 
 local!filteredData: remove(local!array,wherecontains(local!idsnotIncludedforfilter,touniformstring(index(local!array,"Id",{})))),
 local!filteredData
)

Children

No Data