Can we do unpivot functionality in ETL, in the beast mode?
Hey,
I wanted to unpivot two value column, let's say, A & B, in which the first column gives A,B (row wise) and the second column gives its corresponding value. Thus, I can use the first column as filter and value column in the card. When we select either A or B, then the values in the card will change according to that. This is achievable through ETL, but Is there any way to make it through beast mode calculations.
Thanks
Salma
Best Answer
-
Hi @Salmas,
This isn't possible with a beast mode as it's performed on a row by row basis and doesn't have the ability to add rows to your dataset. You'd need to do it with an ETL.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**2
Answers
-
Hi @Salmas,
This isn't possible with a beast mode as it's performed on a row by row basis and doesn't have the ability to add rows to your dataset. You'd need to do it with an ETL.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**2 -
@Salmas what's your use case? what does your data contain and what are you trying to accomplish? it sounds like you have a multi valued column and you want to be able to filter on one value in the multi-valued column.
you can't do that in analyzer gracefully. what you could do is add binary columns for the major values. isOptionA, isOptionB, isOptionC. This will allow you to filter for all rows that contain OptionA or B or C. but that kinda sucks b/c you could end up adding many columns.
the alternative is to duplicate your data such that you have a column Report_Option and then unpivot your multivalue column such that the Option is contained in the new column. This way you could select OptionA and see all the rows that contain OptionA. Of course, if you're looking for the intersection of OptionA and OptionB now your data is double counted (OptionA OR OptionB), whereas the initial proposed solution would show you just OptionA AND OptionB
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0 -
Hi @GrantSmith , Thank You
0 -
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 299 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 55 App Studio
- 40 Variables
- 682 Automate
- 175 Apps
- 451 APIs & Domo Developer
- 46 Workflows
- 10 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive