Toad World® Forums

Is it possible to save an element or step (like Cleanse) from a workbook?

I have a workbook that is getting too cumbersome so I want to try to recreate (part of) it as automation. I haven't been able to figure out how to save or exports some of the steps (queries, query builder files, Cleanse and export steps as separate TDP elements. Especially the "Cleanse" as some of the others can be done with some copy and pasting.

I don't see a way to do this, currently, in v 5.4, and I personally agree that your use case can be valuable. Would be nice to see your suggestion defined on the TDP idea pond here. I will also add it to our internal repository.

Hi - you cannot save the whole cleanse step but you can save the transformations within a cleanse step into your personal library and then reuse them in another workbook. Highlight all of the steps and then use the "save to library " button


And then when you have your new T&C step, you can highlight the sequence in your library and apply to your new dataset