on 01-06-2010 12:39 PM
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....?
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.