Fastest way to append? Magic seems a bit slow
Hello,
I am appending 2 datasets that have a only a few common columns to give me and my clients the ability to bring their plans in without having to join them and cause some duplications. With that being said, does anyone know of a faster way to do this beside append in Magic? I know that fusion cannot do this because the schema needs to be identical, like a union.
Any help would be greatly appreciated, as I am working on showing some of my non-technical clients how to be more self sufficient.
Appreciate you all.
Jerry
Comments
-
How many columns, rows and how long is it taking? Also does the source data not have some sort of ID column to let you join via a MySQL dataflow or is it that the two datasets just don't share a common ID field to join on?
**Make sure to like any users posts that helped you and accept the ones who solved your issue.**0
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
- 100 SQL DataFlows
- 621 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 743 Beast Mode
- 58 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
- 124 Manage
- 121 Governance & Security
- 8 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