topic Re: concatenate values from child job in tSendMail in Talend Studio

concatenate values from child job in tSendMail

gadje1 — Tue, 21 Jul 2020 15:27:08 GMT

I would like to be able to concataned rows from a child job in a tSendMail. Actually i send 1 mail for every row that come from child job.

My child job is used for creating a csv file and it finaly put those rows in a tBufferOutput and the father job catch this rows.

Here's my child job :

Here's the father job :

Is there somebody that knows how to do that ?

THX

Re: concatenate values from child job in tSendMail

manodwhb — Tue, 21 Jul 2020 16:13:00 GMT

@gael GARSON , you need to concatenate before tBufferOutput. from there you will get only one record.

if you have multiple columns club them into single using tJavarow or tMap and then use tAggregaterow to list option and pass that record to tBufferOutput.

Thanks,

Manohar

Re: concatenate values from child job in tSendMail

gadje1 — Wed, 22 Jul 2020 09:14:50 GMT

Hi Manodwhb,

thanks for your answer, i did what you said to me to do and it works well.

My setting data jobs look like that :

As show above, i concatained the columns in single row with tJavaRow.

I aggregate rows into a list with tAggregate component :

And my tSendMail component looks like that :

As show above, i just need to set in form every rows with a carriage return, do you know if is there a way to do that ?

THX