How do I create a script that assigns a value to a new column in MySQL?
I have opportunities that are listed more than once and I need to create a column that ensures its only counted once. Here's a visual example of what I am trying to accomplish Example data: And what I mean to do is assign a value in a new column the first time its encountered and 0 for every time after. So the opportunity is only counted once while still showing the influence. Who the influence gets assigned to isnt important just as long as the TCV is counted once per opportunity. If this is possible by beastmode or Magic ETL I'm open to those solutions as well.
0
Best Answer
-
You can do this through ETL or MySQL
Here is a screenshot of my ETL. If you need more help setting it up let me know and I can provide more detail tomorrow.
If you prefer MySQL, I can work through that code as well. Let me know your preference.
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman2
Answers
-
You can do this through ETL or MySQL
Here is a screenshot of my ETL. If you need more help setting it up let me know and I can provide more detail tomorrow.
If you prefer MySQL, I can work through that code as well. Let me know your preference.
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman2
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 292 Workbench
- 4 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 95 SQL DataFlows
- 602 Datasets
- 2.1K Magic ETL
- 3.7K Visualize
- 2.4K Charting
- 694 Beast Mode
- 43 App Studio
- 39 Variables
- 658 Automate
- 170 Apps
- 441 APIs & Domo Developer
- 42 Workflows
- 5 DomoAI
- 32 Predict
- 12 Jupyter Workspaces
- 20 R & Python Tiles
- 386 Distribute
- 111 Domo Everywhere
- 269 Scheduled Reports
- 6 Software Integrations
- 113 Manage
- 110 Governance & Security
- 8 Domo University
- 30 Product Releases
- Community Forums
- 39 Getting Started
- 29 Community Member Introductions
- 98 Community Announcements
- Domo Community Gallery
- 4.8K Archive