Data Mapper - Count based on condition
I have a database source schema and would like to have a count of total number of occurrences based on condition.
I am using this one
count($Input_Invoice_Advanced_Database_Schema/DB/tblEDIInvoices/Orders/AmTx5 > '0.00')
It is returning 1, which is not true as per the data.
Can you please suggest how to get the total number of occurrences of that particular element based on a condition?
Try the following
The "Orders[AmTx1>0.0000] " will return orders where the AmTx1 value is greater than 0.0000. The count function will then return the number of records that fulfill that condition.0
Post is closed for comments.