a mapping problem

Hello guys,

I’ve got a problem with a mapping.

This is the Input
<AttributeValue__List>
– <AttributeValue attribute__refcode=”Foo” >
– <Attribute__Values>
  <Attribute__Value pos=”1″ text__id=”0″ />
  <Attribute__Value pos=”2″ text__id=”0″ />
  <Attribute__Value pos=”3″ text__id=”0″ />
  <Attribute__Value pos=”4″ text__id=”0″ />
  </Attribute__Values>
  </AttributeValue>
  ….
– <AttributeValue attribute__refcode=”ORDER_UNIT” >
– <Attribute__Values>
  <Attribute__Value pos=”1″ text__id=”332″  />
  <Attribute__Value pos=”2″ text__id=”0″  />
  <Attribute__Value pos=”3″ text__id=”0″  />
  <Attribute__Value pos=”4″ text__id=”0″  />
  </Attribute__Values>
  </AttributeValue>
</AttributeValue__List>

If an AttributValue has the attribute__refcode “ORDER_UNIT”, which just occurs once,
and an Attribute__Value/@text__id which is not 0,
I’d like to take the @text__id and do an Database Lookup, to recieve C62.

I want this
  <ARTICLE_ORDER_DETAILS>
  <ORDER_UNIT>C62</ORDER_UNIT>
  </ARTICLE_ORDER_DETAILS>

But I get this
  <ARTICLE_ORDER_DETAILS />
  …
  <ARTICLE_ORDER_DETAILS />
  <ARTICLE_ORDER_DETAILS>
  <ORDER_UNIT>C62</ORDER_UNIT>
  </ARTICLE_ORDER_DETAILS>

My Mapping looks something like this

If someone could help it would be great

Thanks in advance

Daniel