AnsweredAssumed Answered

Mapping creates multiple elements

Question asked by daniel.schlup601649 on Mar 23, 2018
Latest reply on Mar 23, 2018 by dcollins724067

Hi, I have a simple flat file to XML mapping and one source value is creating multipe target value within the same node. I think that it has to do with the target structure, but I somehow don't see what the actual issue is.

 

 

I have the following flat file with a header line and two records:

 

VKORG;VDATU;KUNNR_AG;KUNNR_WE;BSTKD_H;CUST_POSNR;MENGE;VRKME;BSTKD_I;MATNR;TEXT_I
2621;;20095476;20095476;PORA1700064;10000;1;PCE;200612;0500347P164;ABC123
2621;;20095476;20095476;PORA1700064;40000;1;PCE;107937;0760026P809;XYZ789

 

The problem is with the last field "TEXT_I" called "ItemText" in the flat file structure in Boomi and is mapped as following:

 

 

So, it is really a simple 1:1 mapping of all the fields and the target segment has some default values in addition. The result looks like this:

 

    <E1EDP01 SEGMENT="1">
      <POSEX>10000</POSEX>
      <ACTION>001</ACTION>
      <MENGE>1</MENGE>
      <PMENE>PCE</PMENE>
      <E1EDP02 SEGMENT="1">
        <QUALF>044</QUALF>
        <BELNR>200612</BELNR>
      </E1EDP02>
      <E1EDP19 SEGMENT="1">
        <QUALF>002</QUALF>
        <IDTNR>0500347P164</IDTNR>
      </E1EDP19>
      <E1EDPT1 SEGMENT="1">
        <TDID>9007</TDID>
        <TSSPRAS_ISO>EN</TSSPRAS_ISO>
        <E1EDPT2 SEGMENT="1">
          <TDLINE>ABC123</TDLINE>
          <TDFORMAT>/</TDFORMAT>
        </E1EDPT2>
        <E1EDPT2 SEGMENT="1">
          <TDLINE>XYZ789</TDLINE>
          <TDFORMAT>/</TDFORMAT>
        </E1EDPT2>
      </E1EDPT1>
    </E1EDP01>


    <E1EDP01 SEGMENT="1">
      <POSEX>40000</POSEX>
      <ACTION>001</ACTION>
      <MENGE>1</MENGE>
      <PMENE>PCE</PMENE>
      <E1EDP02 SEGMENT="1">
        <QUALF>044</QUALF>
        <BELNR>107937</BELNR>
      </E1EDP02>
      <E1EDP19 SEGMENT="1">
        <QUALF>002</QUALF>
        <IDTNR>0760026P809</IDTNR>
      </E1EDP19>
      <E1EDPT1 SEGMENT="1">
        <TDID>9007</TDID>
        <TSSPRAS_ISO>EN</TSSPRAS_ISO>
        <E1EDPT2 SEGMENT="1">
          <TDLINE>ABC123</TDLINE>
          <TDFORMAT>/</TDFORMAT>
        </E1EDPT2>
        <E1EDPT2 SEGMENT="1">
          <TDLINE>XYZ789</TDLINE>
          <TDFORMAT>/</TDFORMAT>
        </E1EDPT2>
      </E1EDPT1>

    </E1EDP01>

 

Everything looks as it is supposed to, only this ItemText shows up in both records twice with the value from the first as well as the second record.

 

Maybe it is just something stupid, but somehow I just don't see the cause and any feedback is appreciated.

 

Thanks,

Daniel

Outcomes