REG: How to merge rows into a column

[prabuj]

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]

Hi

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

Regards

Shong

[prabuj]

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

[Anonymous]

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.