topic Re: Aggregating/ Grouping the data in Talend Studio

Aggregating/ Grouping the data

amitdadri — Sat, 16 Nov 2024 01:28:40 GMT

Hi,

I have a requirement , where I have gathered the data in normalised form, now I need to send emails, based on it.

Based on unique (email and KeyData column), I have to send a email. For example for first two line I need to send 1 email, for 3rd line a separate email, and again for 4 and 5 line separate email, as the combination of email and KeyData is different.

FirstName;Email;KeyData;EndDate;Element

Sumit;sumit@gmail.com;A111;2020-08-06;TstEle001

Sumit;sumit@gmail.com;A111;2020-08-06;TstEle022

Ravi;ravi@gmail.com;A111;2020-08-09;TstEle044

Sumit;sumit@gmail.com;A444;2020-08-06;TstEle055

Sumit;sumit@gmail.com;A444;2020-08-01;TstEle044

Can you please suggest on how to group and send it to tSendEmail component.

to the tSendEmail component, I need to pass Element and EndDate fields in the body.

Re: Aggregating/ Grouping the data

Anonymous — Mon, 14 Sep 2020 07:13:38 GMT

You can use tAggreGateRow to group the data based on key columns email and KeyData, and get the list of Element and EndDate fields, then, use a tFlowToIterate to iterate each group and send an email, see below.

Regards

Shong

Re: Aggregating/ Grouping the data

amitdadri — Mon, 14 Sep 2020 07:26:56 GMT

Hi @Shicong Hong

Much thanks for the reply, I did already try this and I'm getting error while grouping as you suggested

Warning:the operation 'list_object' for the output column 'Element' can't be processed because of incompatible input and/or output types

Warning:the operation 'list_object' for the output column 'EndDate' can't be processed because of incompatible input and/or output types

Re: Aggregating/ Grouping the data

Anonymous — Mon, 14 Sep 2020 07:49:51 GMT

I read the data with string type and select 'List' function from the Function List.