topic Re: Bring multiple columns from csv into xml loop in Talend Studio

Bring multiple columns from csv into xml loop

Anonymous — Mon, 02 Apr 2018 11:35:52 GMT

Hello,

i'm new to the talend and im trying to use Talend Open Studio for Data Integration for converting csv into an xml file. I ran into trouble because i am having multiple columns bullet1 - bullet20 which I want to bring into the loop custom-attributes. Basic idea is to use the flatfile columns to fill a new attribute in the xml with the content of the columns. I know whats showed on the image does not work, its just to demonstrate the problem. I got 20 input cols which should each create a xml node inside of custom-attributes.

Any ideas on that?

Big thanks in advance!

Re: Bring multiple columns from csv into xml loop

manodwhb — Mon, 02 Apr 2018 11:41:59 GMT

@kolfe since you need to concatinate columns like row3.bullets1 || row3.bullets2.

try in this way.

Re: Bring multiple columns from csv into xml loop

Anonymous — Mon, 02 Apr 2018 12:21:15 GMT

Thanks for your input. That doublepipe will throw an error: "The operator || is undefined for the argument type(s) java.lang.String, java.lang.String". I could use + to concat but that would put all togehther into the same node and not one custom-attribute node each.

Re: Bring multiple columns from csv into xml loop

manodwhb — Mon, 02 Apr 2018 13:50:00 GMT

yes you can use + to

Re: Bring multiple columns from csv into xml loop

manodwhb — Tue, 03 Apr 2018 10:19:47 GMT

you can add into single node using +

Re: Bring multiple columns from csv into xml loop

Anonymous — Tue, 03 Apr 2018 20:59:34 GMT

xml result should look like this:

...
<custom-attribute>{row3.bullets1}</custom-attribute>
<custom-attribute>{row3.bullets2}</custom-attribute>
<custom-attribute>{row3.bullets3}</custom-attribute>
<custom-attribute>{row3.bullets4}</custom-attribute>
...

not likes this

<custom-attribute>{row3.bullets1} {row3.bullets2} {row3.bullets3} {row3.bullets4}</custom-attribute>