How to merge two rows in one?
Hi,
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:
Account IntegrationBeastMode
AccountA TRUE
AccountB FALSE
Hope this makes sense.
Best Answer
-
Hi @user16640
If only you want to check for that in AccountA then the 1st beastmode would work,
if you want to check for those conditions in all accounts you'll need to remove the condition for accountA using the beastmode number 2 below
BeastMode to check only on AccountA
case when `Account` = 'AccountA'
then case when sum(case when `Integration` in ('IntegrationA', 'IntegrationB')
then 1 else 0 end) = 2
then 'TRUE' else 'FALSE'
end
else 'FALSE' end
BeastMode to check on all accounts where Integration is A and B
case when sum(case when `Integration` in ('IntegrationA', 'IntegrationB')
then 1 else 0 end) = 2
then 'TRUE' else 'FALSE'
endDomo Arigato!
**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'0
Answers
-
Hi @user16640
If only you want to check for that in AccountA then the 1st beastmode would work,
if you want to check for those conditions in all accounts you'll need to remove the condition for accountA using the beastmode number 2 below
BeastMode to check only on AccountA
case when `Account` = 'AccountA'
then case when sum(case when `Integration` in ('IntegrationA', 'IntegrationB')
then 1 else 0 end) = 2
then 'TRUE' else 'FALSE'
end
else 'FALSE' end
BeastMode to check on all accounts where Integration is A and B
case when sum(case when `Integration` in ('IntegrationA', 'IntegrationB')
then 1 else 0 end) = 2
then 'TRUE' else 'FALSE'
endDomo Arigato!
**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'0 -
Thanks this works!!
1
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 747 Beast Mode
- 59 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 395 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 6 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive