Get data from unbound element without using looping functiod

Hello,

This is quite easy using inline XSLT in a map, simply create two Scripting Functoids and use the following Inline XSLT:

<InRefOutputNode>
<xsl:value-of select=”//Instruction/PIValueParameter[@name = ‘InRef’]/@value” />
</InRefOutputNode>

Simply replace the bold @name = ‘InRef’ with @name = ‘OutRef’ to extract that value in your second Scripting Functoid. Further details about how to use this functiod for Inline XSLT can be found at the MSDN website: http://technet.microsoft.com/en-us/library/ms916558.aspx

As an aside, I don’t actually like how the Bts mapper does inline XSLT – the //Instruction designation for starters isn’t valid XSLT and doesn’t start with your root element, which seems a bit strange. Anyway, the XSLT code above works!

Hope this helps, Nick.

The correct answer is not to use inline XSLT. This displays a basic lack of skills with the mapping tool.

The way to properly acheive this is to use a conditional mapper with the logical detecting the desired value of InRef or OutRef as the case may be. Then link the conditional mapper to a cumulative string functoid to get it to loop through all iteration of that element. Evaluate the output of the cumulative to detect non blank and then conditionally map that to the target element.

Depending on the data, you might also need to limit the looping level to 1 by adding the 1 as the second parameter to the cumulative string functoid.