Creating a DataBase on Magic ETL
I have a database with a column Area with differents areas, and other column called "Value" and i want to create a new database grouping all theses areas in just one, but keeping the others columns with the info that it was. I want to do these Magic ETL
Best Answer
-
@luizalauretti You would want Area to be stored as Text with a value of SP.
1
Answers
-
@luizalauretti Can you please provide some anonymized examples of what your data looks like and what you want the result to look like?
It sounds like what you described should be possible in ETL, but I want to be sure I'm understanding correctly before offering suggestions.
0 -
This first Database is what i have, you can look that has two areas (IV and V) and i want to group in one area (like the second table - SP) and sum the values, someone suggest me to use the formulas on Magic Etl, but i have no idea how, lol
0 -
@luizalauretti You should be able to create the second table using a Group By tile in MagicETL that groups by PPG, RE, and TYPE then takes the Sum of VALUE. Then you can use an Add Constants tile to create a new AREA column with a value of "SP".
1 -
Thanks @MichelleH,
it would be like this? (the Group By)
0 -
@luizalauretti Yes, exactly!
0 -
Thanks @MichelleH
I just dont know how to to the "add constants" tile
what i shoul pick up? and then the 'Area' it would be the constant ?
0 -
@luizalauretti You would want Area to be stored as Text with a value of SP.
1 -
Thank you for the help, @MichelleH ! I did it :)
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 297 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 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
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive