concatenate values from child job in tSendMail

[gadje1]

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

[manodwhb · Accepted solution]

@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

[gadje1]

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