Converting single line with comma separated data to xml

[Anonymous]

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

[TRF · Accepted solution]

Hi,

Have look to tNormalize then tXmlMap components.

[Anonymous]

Hi,

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