Hi,
I have searched all over ineternet to find a solution for the mapping issue i am facing but no success. I would highly appreciate it if some one has a solution for the issue i am facing. Following is the scenario i have and the solutions i have tried –
Scenario: I have two looping nodes in the source schema and one looping node in destination schema.Below is the input and output formats that i have.So, i need to create a vehicle for each vehicle i receive and then add coverage value Y or N based on the coverage value existance. I have tried using custom XSLT also and could get to the coverage value but thats not the end value i need. I need to do further processing to determine Y or N. I can achieve this in the XSLT itself in this scenario. But there are other scenarios where once i have the coverage value i need to go to a database and compare the valid values and get the mapped value.
I have tried using a combination of functoids like Table looping and table extractor, looping and others but invain.
Source Data format:
<Vehicle>
<Make>FORD</Make>
<Model>FOCUS</Model>
</Vehicle>
<Vehicle>
<Make>CHRY</Make>
<Model>SEB</Model>
</Vehicle>
<Coverage>
<code>RENTAL</code>
<value>15</value>
</Coverage>
Destination data format:
<Vehicle>
<Make>FORD</Make>
<Model>FOCUS</Model>
<RentalCoverage>Y</RentalCoverage>
</Vehicle>
<Vehicle>
<Make>CHRY</Make>
<Model>SEB</Model>
<RentalCoverage>Y</RentalCoverage>
</Vehicle>
Thanks
Vijay