Data Model Name Child Objects Property Values
datamodel1
childobject1 Description
record1
record2
childobject2 Description
record3
record4
Final output required as through search query not in data model record1
record2
record3
record4
| set union [| datamodel
Above solution is verified and working.
Try this instead http://answers.splunk.com/answers/215346/best-practices-to-join-two-child-objects-of-a-data.html , it will be much faster