topic Re: Need to Generate a XML with Below Given Requirements in Talend Studio

Need to Generate a XML with Below Given Requirements

VNikhil1691525655 — Tue, 08 Aug 2023 20:20:54 GMT

Hello Everyone, I am facing one issue while creating a XML in talend jobs. I need to implement a scenario and create one XML report but I am not able to generate the desired output.

Could any one please help me with this?

As grouping along with multiple loop elements doesn't work in Talend tAdvanceFileOutputXML. How can I achieve below given scenario?

Re: Need to Generate a XML with Below Given Requirements

Anonymous — Wed, 09 Aug 2023 03:49:48 GMT

@Vaidya Nikhil , tAdvanceFileOutputXML does not support multiple loop element, with 'Append the source xml file' option, you are able to append another loop element to an existing xml file, for example,

this job generates a xml file format like this:

<?xml version="1.0" encoding="ISO-8859-15"?>

<name>shong</name>

</details>

<name>elise</name>

</details>

</details>

<details_old>

<name>shong_old</name>

</details_old>

<details_old>

<name>elise_old</name>

</details_old>

<details_old>

</details_old>

</namereport>

</details>

<details_old>

</details_old>

</namereport>

</report>

As you seen, the second loop element </details_old> are appended to an existing xml file under the same group element, but it can't generate the file format as you shown.

Regards

Shong

Re: Need to Generate a XML with Below Given Requirements

VNikhil1691525655 — Wed, 09 Aug 2023 08:04:42 GMT

Hello Shong, Thanks! But if you look at the output the sequence is change now the old tag needs to be just after that corresponding current value tag.

I also implemented the same solution and I know we can only get this output with tAdvancedFileOutputXMl.

I there a way or a workaround to get this desired result. I tried couple of solution but none worked.

Re: Need to Generate a XML with Below Given Requirements

Anonymous — Thu, 10 Aug 2023 02:41:19 GMT

@Vaidya Nikhil A workaround is to use tXMLMap to generate a Document, tXMLMap supports multiple loop element, create a XML file using the incoming Document on tFileOutputXML. The generated XML file looks like:

<?xml version="1.0" encoding="ISO-8859-15"?>

<name>shong</name>

</details>

<details_old>

<name>shong_old</name>

</details_old>

<name>elise</name>

</details>

<details_old>

<name>elise_old</name>

</details_old>

</details>

<details_old>

</details_old>

</Report>

<?xml version="1.0" encoding="ISO-8859-15"?>

</details>

<details_old>

</details_old>

</Report>

After generating the XML file, read the file as a string, and then replace these lines with empty value.

</Report>

<?xml version="1.0" encoding="ISO-8859-15"?>

For more details, please see the below screenshots.

on tJavaRow:

output_row.content = input_row.content.toString();

Hope it helps you.

Regards

Shong