Need to sum child data count and then have to add to profile xml
4 Parent records
4 child records for each parent record
I need to add only parent records with child records count in response xml.
Can you see if you can use Line Item Increment inside mapNumeric functions
I am not sure whether I have understood your requirement. However, what I understand is that you want to get the count of child records of a parent record and then output should have only parent records with respective child counts.
This is what I have designed and works as per my understanding.
1. Split the xml based on Parent
2. use the map to count all child elements and the result should be mapped to destination. Ensure your destination profile has Parent identity as unique.
3. Then combine the documents
Input sample data
Let me whether this is what you wanted.
Retrieving data ...