Question

XLS mapping into one field

  • 27 November 2023
  • 0 replies
  • 8 views

Userlevel 4
Badge +9
  • Sidekick (Customer)
  • 76 replies

Hi all,

 

For the PAIN002 (Payment Status File) from the Bank,  we have a transformer to map the original XML file into the requirements for the File Template.

However, we see one challenge - the transformer  (partly copied below) is representing in 1 C5 tag per appearance. In the loaded External File; we then only see the last record. So below (part of the) XML file, is being transformed into 

 

    <C5>K0290</C5>

      <C5>The payment has been executed</C5>

      <C5>66190,00 DKK</C5>

  

 

	<xsl:for-each select="n1:StsRsnInf">
<xsl:for-each select="n1:AddtlInf">
<C5>
<xsl:value-of select="."/>
</C5>
</xsl:for-each>
</xsl:for-each>

 

<StsRsnInf>
<AddtlInf>K0290</AddtlInf>
<AddtlInf>The payment has been executed</AddtlInf>
<AddtlInf>66190,00 DKK</AddtlInf>
</StsRsnInf>

 

Does anyone know how’s it’s possible to get the values in one C5 tag instead if multiple?
The AddtInf record can appear once, twice or 3 times.


0 replies

Be the first to reply!

Reply