Hey dudes. I'm fairly new to BizTalk and development in general, but very strong in VBScript so the Mapper is pretty comfortable to me. On to my question...
I have a source XML document that has an element which maps to an XML attribute at the destination. On the source side there are several occurences of this element with the same value. Also, the source side is fairly flat. I want to build a hierarchy on the destination side by only creating a single instance of this attribute based on that value.
In other words if element1 has a specific value that occurs 10 times, I want it only to occur ONCE in the destination.
I looked at the looping functoid, but it seems that's only useful in the case where there are greater than 1 source elements (meaning two inputs). I also did some wacky stuff with VBScript in a custom functoid that involved a dictionary object to store the values, then map them after the fact. This all seemed to be way too much, so I opted to pull this solution out of the Mapper and put it into a .NET AIC (which uses HashTables to store the values and build the hierarchy in memory before producing the resulting XML).
Anyone else run into this problem? If so, how did you solve it? Thanks!
I have a source XML document that has an element which maps to an XML attribute at the destination. On the source side there are several occurences of this element with the same value. Also, the source side is fairly flat. I want to build a hierarchy on the destination side by only creating a single instance of this attribute based on that value.
In other words if element1 has a specific value that occurs 10 times, I want it only to occur ONCE in the destination.
I looked at the looping functoid, but it seems that's only useful in the case where there are greater than 1 source elements (meaning two inputs). I also did some wacky stuff with VBScript in a custom functoid that involved a dictionary object to store the values, then map them after the fact. This all seemed to be way too much, so I opted to pull this solution out of the Mapper and put it into a .NET AIC (which uses HashTables to store the values and build the hierarchy in memory before producing the resulting XML).
Anyone else run into this problem? If so, how did you solve it? Thanks!