Without Looping Get data from workday

[Buvi]

{
  Rows: 
[
    
{
      Employee name: Test,
      Geo zone: zone,
      Job profile comp band: Sr.Manager Testing,
      Location: Test,
      Manager: Al-Test,
      Position created date: 2020-03-13T12:02:15.436000-07:00,
      Position ID title: dsfdsflka,
      Position status: Filled
    },

I’m using Workday Get Report activity. I need to match the input Job Profile Comp Band with the input value I’m passing, without using a loop. Once a match is found, I need to extract the Employee Name and EEO Zone.
The comparison should be case-insensitive (using downcase) and should check whether the value contains the input.

[shivakumara]

Hi @Buvi ,
Here I am adding a solution. Please kindly check and let me know if you have any questions.

[francbaviello]

Hi @Buvi , you can use the function 'where' and 'pluck'. example of formula:

array.where(Job profile comp band: 'Sr.Manager Testing').pluck('Employee name')

tell me if you encounter any problems