Grouping into one Row
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.
when `Loan_Originator_Type` = 'Retail' THEN 'Yes'
when `Loan_Originator_Type` = 'Wholesale' THEN 'Yes'
Unfortunately this spits out multiple rows, but I would like to aggregate and group everything into just the parent_wID.