Hierarchy -Child and parent Relationship

Hi Friends,

We are creating flat file to upload hierarchies from flat file source systems. The source file is like below.

Child

Node 1

Node 2

Node 3

Node 4

Node 5

Node 6

Node 7

311000

311220NET-HAW

NTWK-HAWA-REV

TTL-NWHW-REV

TTL-REVENUE

PRE-OH-MARGIN

PBA

PBIT

311000

311220NET-HAW

NTWK-HAWA-REV

TTL-NWHW-REV

TTL-REVENUE

PRE-OH-MARGIN

PBA

PBT

Node 7 is the highest node.

Here for GL account we have same parents and highest level we have different parents values. If we see node 6—we have PBA value; for this we have two parent values PBT and PBIT.

I have created flat file in the below format.

Node ID

InfoObject

Node Name

Link

Parent ID

Language

Short Description

Medium Text

Long Text

1

0HIER_NODE

TEST_TWO_PARENTS

EN

2

ZCSEVENTH

PBIT

1

EN

3

ZCSEVENTH

PBT

1

EN

4

ZCSIXTHLE

PBA

3

EN

5

ZCNINTHLE

PBA

2

EN

6

ZCFIFTHLE

PRE-OH-MARGIN

5

EN

7

ZCFOURTHN

TTL-REVENUE

6

EN

8

ZCTHIRDLE

TTL-NWHW-REV

7

EN

9

ZCSECONDN

NTWK-HAWA-REV

8

EN

10

ZCTOPNODE

311220NET-HAW

9

EN

11

YCOGNOSGL

311000

10

EN

And the output came as like below attched file.

We are expecting same GL account to be assigned with another node as well.

Please guide me how we can configure hierarchy file to get the same GL account values to be assigned to two nodes.