Hi @Sahil,
Here are two expressions, I was not sure because it is array does always will have only one VW that contains ‘F’ in the value.
First expression. Finds all NO or NP that contains ‘F’ in VW field.
$Data.IDOC.A1.filter(e => e.get('VW').contains('F')).map(x => x.get('NO') != null ? x.NO : x.NP)
But I think that the second expression is more correct. This expression finds the first one element in the array that contains ‘F’ in VW, and returns NO if exist or else NP.
$Data.IDOC.A1.find(e => e.get('VW').contains('F')).get('NO', $Data.IDOC.A1.find(e => e.get('VW').contains('F')).get('NP'))
By default this expression return null, and if you want something else you can add second parameter in the get method for default values.
Ex: .get('NP', "Default")
Regards,
Viktor
