Need to query 2 sources in custom render

[Former Community Member]

Hey Jasmin, Jayan, et al,

I have a custom render where I need to query a couple different datasources, then combine that xml and merge with the pdf to display.  Basically I need to pre-populate from two different sources.  I'm having a brain freeze here and not sure of the best way to merge the XML back into one xml variable to merge with the form.  Should I use XSL transform?  I know how to reference xml files in xsl transforms, but how do I reference the xml variables I use for the results from the query multiple to xml?  I have 2 XML variables and need to have only one when merging with the form.

Thoughts?

Thanks

[Former Community Member]

How about a single schema that defines multiple XML docs? You could then map the XML from each data source to a single XML instance that is merged with the form.

Steve