How to merge two rows in one?
Let me show you what my table looks like and what I want to achieve this should be the easiest way to explain:
Account SubAccount Integration
AccountA Subaccount1 IntegrationA
AccountA Subaccount2 IntegrationB
AccountB Subaccount1 IntegrationA
I then want to create an additional column in beast mode that checks if Account A contains IntegrationA and Integration B, if Yes then return TRUE otherwise return FALSE. Something like this:
CASE WHEN AccountA.Integration = (IntegrationA AND Integration THEN 'TRUE' ELSE 'FALSE' END
The result should look like this:
Hope this makes sense.