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é

[Harish]

Hi Andre,

you can achieve this in graphical mapping if you know what is the relation between child and parent node in the source structure. So please provide the relationship between them to provide inputs.

regards,

Harish

[Former Member]

Hi Harish,

the relation is the following as you can see on screenshot of the first post.

OrgSectorID = WELT_NR

Description (on the same level of the target) = WELT_BEZ

1:N WELT_NR : LAGER_GRP_NR

OrgMainDivisionID = LAGER_GRP_NR depending on the OrgSectorID/WELT_NR

Description (on the same level of the target) = LAGER_GRP_BEZ

1:N LAGER_GRP_NR: LAGER_NR

OrgDivisionID = LAGER_NR depending on the OrgMainDivisionID/LAGER_GRP_NR

Description (on the same level of the target) = LAGER_BEZ

Level 1 would look like this...in my opinion:

But honestly I have currently no clue how to get onwards.

Thx in advance.

KR

André