on 11-19-2010 6:49 AM
Hi Experts,
Source Structure:
MT_TEST (1;1)
UTService (1;1)
Request (1;1)
SelectedByCSM (1:Unbounded)
StartDate (0:1)
EndDate (0:1)
where SelectedByCSM,StartDate,EndDate fileds are the element of Reuqest node whereas UTService is the parent node.
UTService 1;1
- - - - - - - - Resuest 1;1
- - - - - - SelectedByCSM (1:Unbounded)
- - - - - - StartDate (0:1)
- - - - - - EndDate (0:1)
Target Structure:
MT_RESULT (1;1)
Request (1:1)
TimeRequest (0;Inbounded)
TimeRange (1:1)
StartDate (0:1)
EndDate (0:1)
where Request is Parent node under TimeRequest and TimeRange, whereas StartDate & EndDate are comes under TimeRange.
Resuest (1;1)
- - - - - - - -> TimeRequest (0;Inbounded)
- - - - - - - -> TimeRange (1;1)
- - - - - - > StartDate (0:1)
- - - - - - > EndDate (0:1)
Requirement: For every SelectedByCSM field the target TimeRequest should create along with TimeRange elements StartDate and EndDate. At present muliple TimeRequest are created but with only first TimeRange populated the StartDate and EndDate values and for rest TimeRequest values are not filled.
Sameer!
Hi Sameer,
Try with the below logic:
Source> Collapse context>Splitbyvalue(eachvalue)-->Target
Thanks,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Can you confirm your mapping , Since Time range is a separate node Time request is a separate node
We can create time request as many times since ocurrence is 0-unbounded
But time range being a separate node and occurence 1-1 will occur only once in the complete document
If i am not wrong
regards
Ninad
User | Count |
---|---|
95 | |
11 | |
10 | |
9 | |
9 | |
7 | |
6 | |
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.