Mapper Snap : Help with JsonPath

[DaisyTam]

Hi

I appreciate some help in transform the attached input to the attached output.

I have tried using the mapper snap with the following expression
$person.jive.profile[?(value.jive_label == ‘Country’)].value
$person.jive.profile[?(jive_label == ‘Country’)].value

And is getting syntax error.

input.txt (636 Bytes)
output.txt (191 Bytes)

[nganapathiraju]

Another way

jsonPath($, "$person.jive.profile[?( @.jive_label=='Country' && @.value != '' )].value").toString()