topic Re: REG: How to merge rows into a column in Talend Studio

REG: How to merge rows into a column

prabuj — Fri, 15 Nov 2024 21:45:34 GMT

Dear Team, @Shicong Hong @Xiaodi Shi @Fred Trebuchet

I have a scenario requested from my team. Please suggest how to get policy list like that.

Thanks & Regards,

Prabhakaran Rajendran

Anonymous — Mon, 29 May 2023 08:16:53 GMT

Take a look at tAggregateRow component, I think this component can fit you need. PID is the group element?

Regards

Shong

prabuj — Mon, 29 May 2023 08:59:51 GMT

@Shicong Hong how do you generate policy list ? it's easy to group by PID.

Anonymous — Mon, 29 May 2023 11:09:07 GMT

there is a list function available in the function list.

group element: PID

policy_no, use first function

Fname, use first function

Lname, use first function

DOB, use the first function

Gender, use the first function

policy_list, use list function.