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

1 ACCEPTED SOLUTION

Accepted Solutions
Twelve Stars TRF
Twelve Stars

Re: Converting single line with comma separated data to xml

Hi,

Have look to tNormalize then tXmlMap components.

TRF
2 REPLIES
Twelve Stars TRF
Twelve 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 !