I want to be able to group the parent_wID field so that it is one row per entry. As you can see, the Retail/Wholesale columns are build from beast modes from a separate field. This is the syntax i used to separate those.
"Retail"
(CASE
when `Loan_Originator_Type` = 'Retail' THEN 'Yes'
else 0
end)
"Wholesale"
(CASE
when `Loan_Originator_Type` = 'Wholesale' THEN 'Yes'
else 0
end)
Unfortunately this spits out multiple rows, but I would like to aggregate and group everything into just the parent_wID.
