topic Re: Iterate data from tJava in Talend Studio

Iterate data from tJava

gadje1 — Fri, 31 Jan 2020 13:07:06 GMT

Hi everybody,

I would be able to iterate on data from a tJava Component and put all rows in a tMap or in a tFileOutputDelimited for example.

Here is my job :

If someone knows how to do ...

Thanks a lot.

Re: Iterate data from tJava

Anonymous — Fri, 31 Jan 2020 13:20:50 GMT

Hi,

After your tjava component, put a tFileOutputDelimited or whatever,

pull a "main" link between your tjava and the Output Component

you will see the main link named "rowX".

In tjava write :

rowX.value = ((String)globalMap.get("row1.value"));

Regards,

Pierre

Re: Iterate data from tJava

gadje1 — Fri, 31 Jan 2020 15:18:33 GMT

Merci beaucoup, jesuisengalere.

C'est exactement ce que je souhaite faire.

Fonctionne impeccable.

Bon WE

Re: Iterate data from tJava

gadje1 — Mon, 03 Feb 2020 10:55:03 GMT

Hi Jesuisengalere,

Your solution is right for outputs in console mode but if i want rescue the data in a tFileoutputDelimited i juste have the last data line. Is there a solution to write all the lines in a CSV file ? I guess that there is but i dont know the way to do it.

Here is my job :

Thanks a lot.

Re: Iterate data from tJava

Anonymous — Mon, 03 Feb 2020 13:25:02 GMT

On the tfileoutputDelimited component, you have a 'Append file' checkbox or 'Ecrire après' in French Version.

Regards

Pierre

Re: Iterate data from tJava

gadje1 — Mon, 03 Feb 2020 13:39:16 GMT

i saw the checkbox but is there an other solution because if i do it like that, i'll need to delete my file everytime that i will execute my job.

Re: Iterate data from tJava

Anonymous — Mon, 03 Feb 2020 14:06:24 GMT

The append checkbox permits to write after the selected documents, if it doesnt exist, it will be initialised.

If you have an error telling you that the file already exists, you will have to uncheck a 'die if file exists' checkbox located in the Advanced Setting of the components if i remember right.