How do I aggregate multiple columns with the tAggregateRow component?

Jj5 — Sat, 16 Nov 2024 02:53:38 GMT

I have a use case that follows:

LoanID | Address | PolicyNo | InsuranceType

101 | 123 Main St | Pol123 | Hazard

101 | 123 Main St | Pol122 | Flood

101 | 101 Open Blvd | Pol2 | Flood

102 | 111 Second St | Pol111 | Hazard

102 | 111 Second St | Pol333 | Flood

103 | 137 Third St | Pol222 | Wind

103 | 119 Fifth St | Pol 1234 | Hazard

I need to return the rows that have duplicate LoanIDs and also duplicate Addresses and not having the value "Hazard" as the InsuranceType. So with the sample data set I would need it to return only

101 | 123 Main St | Pol122 | Flood

102 | 111 Second St | Pol333 | Flood

Re: How do I aggregate multiple columns with the tAggregateRow component?

manodwhb — Wed, 25 Mar 2020 01:01:13 GMT

You can do with many ways. Try to do with use tsortrows by sorting on loanid and address and use tuniquerows component and take duplicate records from main. If your seeing any deference you need to play with sorting the data in required way.

topic How do I aggregate multiple columns with the tAggregateRow component? in Talend Studio

How do I aggregate multiple columns with the tAggregateRow component?

Re: How do I aggregate multiple columns with the tAggregateRow component?