1 Solution
Accepted Solutions
Hi Arnaud,
Let me be a bit more clearer....
What I intended to say was that instead of creating the complete XML structure in one-go, you should build it part-by-part (SINCE THERE ARE MULTIPLE LOOPING ELEMENTS, & no components support that.)
Also, component tWriteXMLField is employed to write/create an XML structure only.
Try the below approach:
1. Extract STUDENT records iteratively, like
Student table input --> tFlowtoIterate --> tJava (which can link to further sub-jobs on 'onComponentOK' trigger), to process each row one-by-one
2. Then, you can build the following structure using a tWriteXMLField component:
<SCHOOL>
<STUDENTS>
<STUDENT>
<NAME>JOHN DOE</NAME>
<BIRTH>13-07-1983</NAISSANCE>
<SEX>M</SEX>
<DRIVING_LICENCE>8</DRIVING_LICENCE>
</STUDENT>
</STUDENTS>
</SCHOOL>
This can be achieved by extracting required fields & populating them in appropriate place-holders in the tWriteXMLField component. (There won't be any need for normalizing this data) Looping element in tWriteXMLField would be '<STUDENT>'.
Then, save the thus created XML in globalmap, using XMLutils commands.
3. Then, using 2 different pipelines you need to extract the 'SPORTS' & 'ACTIVITIES' data, normalize it, create XML structure like below using tWriteXMLField component & populate it
SPORTS>
<SPORT>BaseBall</SPORT>
<SPORT>Soccer</SPORT>
<SPORT>Tennis</SPORT>
</SPORTS>
<ACTIVITIES>
<ACTIVITY>Library</ACTIVITY>
<ACTIVITY>Cooking</ACTIVITY>
</ACTIVITIES>
After creation of each of the above XMLs, merge the SPORTS xml into SCHOOL xml using XMLutils commands.
4. The above process will iterate for each incoming STUDENT record.
5. Once the complete XML is ready, we can then write it to a file using tFileOutputXML or tAdvancedFileOutputXML components, based on your need.
The above is a high-level outlined approach. you may need to fill up the gaps at a couple of places.
MathurM
Let me be a bit more clearer....
What I intended to say was that instead of creating the complete XML structure in one-go, you should build it part-by-part (SINCE THERE ARE MULTIPLE LOOPING ELEMENTS, & no components support that.)
Also, component tWriteXMLField is employed to write/create an XML structure only.
Try the below approach:
1. Extract STUDENT records iteratively, like
Student table input --> tFlowtoIterate --> tJava (which can link to further sub-jobs on 'onComponentOK' trigger), to process each row one-by-one
2. Then, you can build the following structure using a tWriteXMLField component:
<SCHOOL>
<STUDENTS>
<STUDENT>
<NAME>JOHN DOE</NAME>
<BIRTH>13-07-1983</NAISSANCE>
<SEX>M</SEX>
<DRIVING_LICENCE>8</DRIVING_LICENCE>
</STUDENT>
</STUDENTS>
</SCHOOL>
This can be achieved by extracting required fields & populating them in appropriate place-holders in the tWriteXMLField component. (There won't be any need for normalizing this data) Looping element in tWriteXMLField would be '<STUDENT>'.
Then, save the thus created XML in globalmap, using XMLutils commands.
3. Then, using 2 different pipelines you need to extract the 'SPORTS' & 'ACTIVITIES' data, normalize it, create XML structure like below using tWriteXMLField component & populate it
SPORTS>
<SPORT>BaseBall</SPORT>
<SPORT>Soccer</SPORT>
<SPORT>Tennis</SPORT>
</SPORTS>
<ACTIVITIES>
<ACTIVITY>Library</ACTIVITY>
<ACTIVITY>Cooking</ACTIVITY>
</ACTIVITIES>
After creation of each of the above XMLs, merge the SPORTS xml into SCHOOL xml using XMLutils commands.
4. The above process will iterate for each incoming STUDENT record.
5. Once the complete XML is ready, we can then write it to a file using tFileOutputXML or tAdvancedFileOutputXML components, based on your need.
The above is a high-level outlined approach. you may need to fill up the gaps at a couple of places.
MathurM
Hi Arnaud,
Let me be a bit more clearer....
What I intended to say was that instead of creating the complete XML structure in one-go, you should build it part-by-part (SINCE THERE ARE MULTIPLE LOOPING ELEMENTS, & no components support that.)
Also, component tWriteXMLField is employed to write/create an XML structure only.
Try the below approach:
1. Extract STUDENT records iteratively, like
Student table input --> tFlowtoIterate --> tJava (which can link to further sub-jobs on 'onComponentOK' trigger), to process each row one-by-one
2. Then, you can build the following structure using a tWriteXMLField component:
<SCHOOL>
<STUDENTS>
<STUDENT>
<NAME>JOHN DOE</NAME>
<BIRTH>13-07-1983</NAISSANCE>
<SEX>M</SEX>
<DRIVING_LICENCE>8</DRIVING_LICENCE>
</STUDENT>
</STUDENTS>
</SCHOOL>
This can be achieved by extracting required fields & populating them in appropriate place-holders in the tWriteXMLField component. (There won't be any need for normalizing this data) Looping element in tWriteXMLField would be '<STUDENT>'.
Then, save the thus created XML in globalmap, using XMLutils commands.
3. Then, using 2 different pipelines you need to extract the 'SPORTS' & 'ACTIVITIES' data, normalize it, create XML structure like below using tWriteXMLField component & populate it
SPORTS>
<SPORT>BaseBall</SPORT>
<SPORT>Soccer</SPORT>
<SPORT>Tennis</SPORT>
</SPORTS>
<ACTIVITIES>
<ACTIVITY>Library</ACTIVITY>
<ACTIVITY>Cooking</ACTIVITY>
</ACTIVITIES>
After creation of each of the above XMLs, merge the SPORTS xml into SCHOOL xml using XMLutils commands.
4. The above process will iterate for each incoming STUDENT record.
5. Once the complete XML is ready, we can then write it to a file using tFileOutputXML or tAdvancedFileOutputXML components, based on your need.
The above is a high-level outlined approach. you may need to fill up the gaps at a couple of places.
MathurM
Let me be a bit more clearer....
What I intended to say was that instead of creating the complete XML structure in one-go, you should build it part-by-part (SINCE THERE ARE MULTIPLE LOOPING ELEMENTS, & no components support that.)
Also, component tWriteXMLField is employed to write/create an XML structure only.
Try the below approach:
1. Extract STUDENT records iteratively, like
Student table input --> tFlowtoIterate --> tJava (which can link to further sub-jobs on 'onComponentOK' trigger), to process each row one-by-one
2. Then, you can build the following structure using a tWriteXMLField component:
<SCHOOL>
<STUDENTS>
<STUDENT>
<NAME>JOHN DOE</NAME>
<BIRTH>13-07-1983</NAISSANCE>
<SEX>M</SEX>
<DRIVING_LICENCE>8</DRIVING_LICENCE>
</STUDENT>
</STUDENTS>
</SCHOOL>
This can be achieved by extracting required fields & populating them in appropriate place-holders in the tWriteXMLField component. (There won't be any need for normalizing this data) Looping element in tWriteXMLField would be '<STUDENT>'.
Then, save the thus created XML in globalmap, using XMLutils commands.
3. Then, using 2 different pipelines you need to extract the 'SPORTS' & 'ACTIVITIES' data, normalize it, create XML structure like below using tWriteXMLField component & populate it
SPORTS>
<SPORT>BaseBall</SPORT>
<SPORT>Soccer</SPORT>
<SPORT>Tennis</SPORT>
</SPORTS>
<ACTIVITIES>
<ACTIVITY>Library</ACTIVITY>
<ACTIVITY>Cooking</ACTIVITY>
</ACTIVITIES>
After creation of each of the above XMLs, merge the SPORTS xml into SCHOOL xml using XMLutils commands.
4. The above process will iterate for each incoming STUDENT record.
5. Once the complete XML is ready, we can then write it to a file using tFileOutputXML or tAdvancedFileOutputXML components, based on your need.
The above is a high-level outlined approach. you may need to fill up the gaps at a couple of places.
MathurM