replace a Dataset within SQL workflow and within transforms

GIriarte

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)

jaeW_at_Onyx

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.

DataMaven

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.