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.
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