Graphical Mapping - Flat to Structure

[Former Member]

Dear all,

I need some help with the conversion of flat data to structural data.

Level 1 is not the problem. What I would do here is:

WELT_NR -> RemoveContexts -> SplitByValue (Value change) -> CollapsContexts -> SplitByValue (Each value) -> OrgSectorId

... the same for node OrgSector_FN_1

The problem is a bit the depending nodes and also the depending descriptions on each level.

Example:

<?xml version="1.0" encoding="UTF-8"?>
<ns0:MT_DB_Welt_WSOGruppe_WSO xmlns:ns0="urn:eb.de:sys:DB">
   <row>
      <WELT_NR>1</WELT_NR>
      <WELT_BEZ>1</WELT_BEZ>
      <LAGER_GRP_NR>1</LAGER_GRP_NR>
      <LAGER_GRP_BEZ>1</LAGER_GRP_BEZ>
      <LAGER_NR>1</LAGER_NR>
      <LAGER_BEZ>1</LAGER_BEZ>
   </row>
   <row>
      <WELT_NR>1</WELT_NR>
      <WELT_BEZ>1</WELT_BEZ>
      <LAGER_GRP_NR>2</LAGER_GRP_NR>
      <LAGER_GRP_BEZ>2</LAGER_GRP_BEZ>
      <LAGER_NR>1</LAGER_NR>
      <LAGER_BEZ>1</LAGER_BEZ>
   </row>
   <row>
      <WELT_NR>1</WELT_NR>
      <WELT_BEZ>1</WELT_BEZ>
      <LAGER_GRP_NR>2</LAGER_GRP_NR>
      <LAGER_GRP_BEZ>2</LAGER_GRP_BEZ>
      <LAGER_NR>2</LAGER_NR>
      <LAGER_BEZ>2</LAGER_BEZ>
   </row>
   <row>
      <WELT_NR>1</WELT_NR>
      <WELT_BEZ>1</WELT_BEZ>
      <LAGER_GRP_NR>3</LAGER_GRP_NR>
      <LAGER_GRP_BEZ>3</LAGER_GRP_BEZ>
      <LAGER_NR>1</LAGER_NR>
      <LAGER_BEZ>1</LAGER_BEZ>
   </row>
   <row>
      <WELT_NR>2</WELT_NR>
      <WELT_BEZ>2</WELT_BEZ>
      <LAGER_GRP_NR>1</LAGER_GRP_NR>
      <LAGER_GRP_BEZ>1</LAGER_GRP_BEZ>
      <LAGER_NR>1</LAGER_NR>
      <LAGER_BEZ>1</LAGER_BEZ>
   </row>
</ns0:MT_DB_Welt_WSOGruppe_WSO>

I would appreciate if s.o. can illustrate me the solution. Priority is the usage of the grafical mapping.

Thx in advance.

Kind regards.

André

[josantonio_roldnluna]

Hi Andre,

I think you can solve it changing filed context on target structure for each inboud field. For do that, you should edit your mapping, and righ clic on inbound field and select an upper context.

If I understood well I think It solve your problem.