cancel
Showing results for 
Search instead for 
Did you mean: 

pass Even segments to Target field

Former Member
0 Kudos

I have source structure

Line(0---Unbounded)

Field1

Field2

Field3

Field4

so on........

I have target stucure

TARG

TRG1

TRG2

TARG is mapped with Line. TARG repeat as number of time Line.

In field TRG1 i have to pass Field1,Field3,Field5--all odd segment comimg under Line.

In field TRG2 i have to pass Field2,Field4,Field6--all even segment comimg under Line.

Can I achive this in Graphical Mapping....?

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Latha,

Take half of the line node occurance and map to the TARG.

Remaining mapping is same.

Based on the source fields you can map the fields like

field1 - TRG1

Field2-TRG2

field3 - TRG1

Field4-TRG2

field5 - TRG1

Field6-TRG2

............

Regards

Ramesh

Former Member
0 Kudos

as you said for doing this mapping I need to Created Duplicate node for TARG..

This duplicate nodes based on occurance of Source i.e. line.

Can you please tell me in how it we achive in Graphical Mapping? (add some arrow or something to show Line-> TARG mapping)

Former Member
0 Kudos

Hi,

Take half of the line node occurance and map to the TARG. (suppose we have 10 occurances in source side then take half of that means 5)

Line(0---Unbounded) -


> length/2 Function or write UDF -


> TARG

Field1

. Concatenate TRG1

Field3

...........

Field2

. Concatenate TRG2

Field4

..............

Regards

Ramesh

former_member187339
Active Contributor
0 Kudos

Hi Harshalata,

>>Can I achive this in Graphical Mapping....?

Looking at your example, Yes you can.. Duplicate the target node and do a 1:1 mapping..

Regards

Suraj

Former Member
0 Kudos

Hi

that wont work ..

Source strucutre contains many fields like field1,field2...........Fieldn.

If Line occurs 5 Times.. then TARG field should occured 5 Times.

and value should passed like this

TRG->1st OCc

field1 - TRG1

Field2-TRG2

TRG->2nd Occur

field3 - TRG1

Field4-TRG2

TRG->3rd Occur

field5 - TRG1

Field6-TRG2

TRG->4th Occur

field7- TRG1

Field8-TRG2

TRG->5th Occur

field9 - TRG1

Field10-TRG2