Converting single line with comma separated data to xml

Highlighted
Four Stars

Converting single line with comma separated data to xml

Hi all,

 

I want to build the following job :

- Process an incoming flow (String) with a unique line containing "Code1;Code2;Code3;...;CodeN"

- Build an XML file looking like that :

<codes>

 <code>Code1</code>

 <code>Code2</code>

 <code>Code3</code>

 ...

 <code>CodeN</code>

<codes>

 

I've been trying for hours using components like tPivotColumnDelimited, tSplitRow, tFlowToIterate unsuccessfully.

 

Many thanks for your help.

 

Best Regards


Accepted Solutions
Forteen Stars TRF
Forteen Stars

Re: Converting single line with comma separated data to xml

Hi,

Have look to tNormalize then tXmlMap components.

TRF

All Replies
Forteen Stars TRF
Forteen Stars

Re: Converting single line with comma separated data to xml

Hi,

Have look to tNormalize then tXmlMap components.

TRF
Four Stars

Re: Converting single line with comma separated data to xml

Hi,

 

Sorry for my late answer. I've just tried with these 2 components and it works very well, thank you !

 

 

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.