How do I aggregate multiple columns with the tAggregateRow component?
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
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.
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.
