1 person found this helpful
I don't think it is possible to nest the XML mapping.
This is because your table data will be just two-dimentional. Through your table return several keywords for each template, the query result will look something like:
template_key id ver keyword
------------------- --- ---- ---------------
tkey1 INSTLP0001a 1.2 key 1 v1.2
tkey1 INSTLP0001a 1.2 key 2 v1.2
tkey1 INSTLP0001a 1.2 key 3 v1.2
Look at the above exhibit. all the column except keyword are repeated.
So, you can achieve this in two ways.
1. Change your schema to have a one level data mapping.
2. Split your schema into three so that you will have three xml files.
Hope this may help you!
Thanks for your reply.
Since I do not control the schema, I have developed a process that runs 3 queries, and uses substring functions to concat and merge the results into the structure called out by the schema.
Not what I would have preferred, but the volume will be low, and not time sensitive.
Substring will be a time consuming operation. Would you prefer combining xmls without converting them into strings?
The other alternative could be to use the XSLT service to re-arrange the xml the way you want.
I have not worked with that service before.
Does it work with the repeating nodes output by the Query Multiple?
Do you have any examples?
I would prefer to avoid string functions, if possible.
It's just a standard xlst service.
You give it xml as an input and it gives out the updated xml as an output based on you xslt.
All the logic is in the xslt.
I did a sample to combine the XMLs for your case. Since your requirement is small, I did it without using XSLT.
I tried a couple of times to access the LCA you posted, but am getting the following error in the preview step:
Error previewing archive: 'C:\WINDOWS\Temp\adobejb_server1\ArchiveStore\4001\XML Merge Test\1.0\schemas\1.xsd (The system cannot find the path specified)'
Do you know what the issue might be?
Thanks for your help