Importing an XML as the Output Schema for a tAdvancedFileOutputXML with same attribute id's in different tags as schema

Four Stars

Importing an XML as the Output Schema for a tAdvancedFileOutputXML with same attribute id's in different tags as schema

Hi Guys,

 

I'm trying to import an XML which has same attribute id in different fields as an output schema for a tAdvancedOutputXML. During the import wizard Talend reads and shows the XML properly with attributes. But when it's imported attributes are being renamed with 1...2..3 at the end. For ex:

item_list

item_list1

item_list2

Item_list3 ...etc

 

I have tried manually adding them as attributes as well, but outcome was the same. For ex:

 

Screen Shot 2018-10-12 at 16.26.04.png

I have attached a sample XML which i'm trying to input as the schema. Anyone else has come across this?

 

Thanks,

 

Regards,

Hasitha

 

Moderator

Re: Importing an XML as the Output Schema for a tAdvancedFileOutputXML with same attribute id's in different tags as schema

Hello,

Maybe the 'append the source xml file' feature on tAdvacedFileOutputXML address your need?

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Seven Stars

Re: Importing an XML as the Output Schema for a tAdvancedFileOutputXML with same attribute id's in different tags as schema

for such scenarios you can either use tAdvancedFileOutputXml more than once and check the append checkbox in every except first 

or you should make use of the loop option in it.

these two would fulfill your requirement.

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Download