Hoping it is Ok to ask Biztalk Q here?
I have a warm feeling that I will end up writing an XSLT scrip functoid for this task anyway.
The map on the left contains a zoo of different elements within their own hierarchies, plus a collection of named name/value sets.
The name/value sets have to be simply copied to the right, but!
Certain elements from the left have to be dumped into one of the named name/value sets under given names.
Basically, the left side looks like that:
elem1
elem2
elem3
listofNVS
NVS name=ABC
name/value pair 1
name/value pair 2
name/value pair 3
NVS name=XYZ
name/value pair 11
name/value pair 22
name/value pair 33
On the right side I need:
listofNVS
NVS name=ABC
name/value pair 1
name/value pair 2
name/value pair 3
name/value pair elem1
name/value pair elem3
NVS name=XYZ
name/value pair 11
name/value pair 22
name/value pair 33
Is that achievable using the visual functoids?
By now someone has put a lot of effort into gathering all the left side elements that need to be converted into NVPs, and feeding them into a table looper. At that point I inherited the project. But this thing does not work together with a simple loop that copies the name/value sets, nor it works with a mass copier.
I am able to get the NVSs across, but not the random elements.
I am hoping that the existing table looper is re-usable, but I can't think of the way.
|
