replace a Dataset within SQL workflow and within transforms
I think could be great to be able to replace a Dataset in a SQL workflow with a new one, not only adding the new data set but as well replacing Dataset name within all transforms. Maybe adding an option to Edit, Delete (image 1) (Replacing if dataset name on sql statement is "name").
Let's say, I have a new data set (using image sample) "EmploymentCycleUpgraded" and then should be replaced with "EmploymentCycleUpgraded_v2".
Not sure if possible or is already available.
This is, by nature, available on Magic ETL (image 2)
it is possible. you'll notice that in your screenshot the name of the dataset is aliasedfrom EmploymentCycleUpgraded to employmentcycleupgraded.
if you wanted to swap in a new dataset to your ETL, just add it in and then change the alias.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"1
That's how I do it, too. It's annoying to not be able to just click on it and change the dataset, but I can see why they did it that way. A new dataset would likely automatically update the alias and break everything. The solution @jaeW_at_Onyx suggested works perfectly every time, as long as the new dataset has the right structure.DataMaven
Breaking Down Silos - Building Bridges
**Say "Thanks" by clicking a reaction in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0
- 10.5K All Categories
- 5 Connect
- 915 Connectors
- 250 Workbench
- 459 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 476 Datasets
- 186 Visualize
- 250 Beast Mode
- 2.1K Charting
- 11 Variables
- 78 Cards, Dashboards, Stories
- 16 Automate
- 354 APIs & Domo Developer
- 88 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 245 Distribute
- 62 Domo Everywhere
- 242 Scheduled Reports
- 20 Manage
- 41 Governance & Security
- 170 Product Ideas
- 1.2K Ideas Exchange
- 10 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive