topic Re: Generate 1 row from multiple rows Talend in Talend Studio

Generate 1 row from multiple rows Talend

Reims — Mon, 29 Jun 2020 16:06:31 GMT

i have fields like this

with this kind of sample data

|Marketing|1|Holydays|Henri|2019-10-03T07:00:00.000Z|2019-10-03T15:00:00.000Z|
|Marketing|1|Holydays|Henri|2019-10-04T07:00:00.000Z|2019-10-

To see the whole post, download it here

Re: Generate 1 row from multiple rows Talend

Anonymous — Tue, 30 Jun 2020 03:44:38 GMT

Hi
I think tAggregateRow component can meet your needs, please read the component documentation and learn this component, let me know if you have any questions.

Regards
Shong

Re: Generate 1 row from multiple rows Talend

Anonymous — Tue, 30 Jun 2020 03:44:38 GMT

Hi
I think tAggregateRow component can meet your needs, please read the component documentation and learn this component, let me know if you have any questions.

Regards
Shong

Re: Generate 1 row from multiple rows Talend

Reims — Tue, 30 Jun 2020 08:17:17 GMT

Hi Shong,

Thanks for your answer. yes i read a little bit about this component, and it almost works.

The only thing is that it is not considering the consecutive days, so i m tryin to add one condition.

for example if paul has holydays from 02.06.2019 to 10.06.2019 and then from 15.09.2019 to 20.09.2019

By grouping on EmployeeNr, Reason and applying the min function on the start time and max function on the end time,

The result will be like Paul had holydays from 02.06.2019 to 20.09.2019.

Reims

Re: Generate 1 row from multiple rows Talend

Reims — Tue, 30 Jun 2020 08:17:17 GMT

Hi Shong,

Thanks for your answer. yes i read a little bit about this component, and it almost works.

The only thing is that it is not considering the consecutive days, so i m tryin to add one condition.

for example if paul has holydays from 02.06.2019 to 10.06.2019 and then from 15.09.2019 to 20.09.2019

By grouping on EmployeeNr, Reason and applying the min function on the start time and max function on the end time,

The result will be like Paul had holydays from 02.06.2019 to 20.09.2019.

Reims

Re: Generate 1 row from multiple rows Talend

JohnRMK — Tue, 30 Jun 2020 09:39:13 GMT

Hello,

You can group by name and number,

For the dates, I advise you to use the tAggregateRow component again, this time with the min and max function. so you will have the start and end date of your holiday

Re: Generate 1 row from multiple rows Talend

JohnRMK — Tue, 30 Jun 2020 09:39:13 GMT

Hello,

You can group by name and number,

For the dates, I advise you to use the tAggregateRow component again, this time with the min and max function. so you will have the start and end date of your holiday

Re: Generate 1 row from multiple rows Talend

Reims — Tue, 30 Jun 2020 09:46:56 GMT

Hi John,

Thanks for your answer. As said earlier it almost works.

The only thing is that it is not considering the consecutive days, so i m tryin to add one condition.

for example if paul has holydays on 02.06.2019, 03.06.2019, 04.06.2019, 05.06.2019, 06.06.2019, 07.06.2019, 08.06.2019, 09.06.2019 10.06.2019 and then

on 15.09.2019, 16.09.2019, 17.09.2019, 18.09.2019, 19.09.2019 and 20.09.2019

By grouping on EmployeeNr, Reason and applying the min function on the start time and max function on the end time,

The result will be like Paul had holydays from 02.06.2019 to 20.09.2019.

Or i want to obtain is Paul had holydays from 02.06.2019 to 10.06.2019. an then paul had holydays again from 15.09.2019 to 20.09.2019.

Reims

Re: Generate 1 row from multiple rows Talend

Reims — Tue, 30 Jun 2020 09:46:56 GMT

Hi John,

Thanks for your answer. As said earlier it almost works.

The only thing is that it is not considering the consecutive days, so i m tryin to add one condition.

for example if paul has holydays on 02.06.2019, 03.06.2019, 04.06.2019, 05.06.2019, 06.06.2019, 07.06.2019, 08.06.2019, 09.06.2019 10.06.2019 and then

on 15.09.2019, 16.09.2019, 17.09.2019, 18.09.2019, 19.09.2019 and 20.09.2019

By grouping on EmployeeNr, Reason and applying the min function on the start time and max function on the end time,

The result will be like Paul had holydays from 02.06.2019 to 20.09.2019.

Or i want to obtain is Paul had holydays from 02.06.2019 to 10.06.2019. an then paul had holydays again from 15.09.2019 to 20.09.2019.

Reims