try something like this:
Sector_MDMId - removeContext - UDF1 - Sector_MDMId
Sector_MDMId - removeContext - UDF2 - SETA_MDMId
SETA_MDMId - removeContext /
UDF1:
[code]...
for (int i=0; i < a.length; i++) {
String output[] = a<i>.split(", ");
for (int j = 0; j < output.length; j++) {
result.addValue(output[j]);
}
}
...[/code]
UDF2:
[code]...
for (int i=0; i < a.length; i++) {
String output[] = a<i>.split(", ");
for (int j = 0; j < output.length; j++) {
result.addValue(b<i>);
}
}
...[/code]
Though since you use a similar logic for both fields, making it as UDF is not the smartest (because you'll execute the same logic at least twice). You could also try out a XSLT with something like:
[code]...
<xsl:template match="/SectorsSETAs">
<SectorsSETAs>
<xsl:for-each select="SectorSETA">
<xsl:variable name="sectors" select="fn:tokenize(string(Sector_MDMId), ',\s+')"/>
<xsl:variable name="seta" select="SETA_MDMId"/>
<xsl:for-each select="$sectors">
<SectorSETA>
<Sector_MDMId>
<xsl:value-of select="."/>
</Sector_MDMId>
<SETA_MDMId>
<xsl:value-of select="$seta"/>
</SETA_MDMId>
</SectorSETA>
</xsl:for-each>
</xsl:for-each>
</SectorsSETAs>
</xsl:template>
...[/code]
Regards,
Henrique.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.