SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Copy n paste transformations

Reply
Occasional Contributor
Posts: 6

Copy n paste transformations


Hi,

Is there a way to copy and paste transformations from one job to another?  I know you can copy the job but are there any options to copy the transformations (and input/output tables).

Cheers!

Super Contributor
Posts: 349

Re: Copy n paste transformations

Hi,

I am not able to understand copy and paste transformation.

If you want your job or input/output tables to copied then you can make .spk file and import where ever you want .

If the transformation is a generated transformation then you can specify your own path and transformation will be saved and you can use this by just drag and drop in your jobs.

Thanks,

Shiva

Occasional Contributor
Posts: 6

Re: Copy n paste transformations

Say I have a transformation in jobA with specefic options/parameters set. I want to copy the transformation to JobB.  I can drag the default transformation but will have to go through and set the parameters/options again.  Is there a way to copy the existing transformation in a job to another job so that it preserves the options/parameters/precode etc etc?

Hope thats clear.

Thanks,

Super User
Posts: 5,257

Re: Copy n paste transformations

No, there are no direct way to copy parts of jobs into another job.

On way to do it is to copy the whole job, then delete the unwanted parts in the copied job.

If you have a part of job that is generic, or very similar between jobs, you might want to explore the possibilities to reuse the code in another way. This could be by isolate it to a job, which can be called from other jobs. Or, if you are using user written code, make a user written transform.

/Linus

Data never sleeps
Senior User
Posts: 1

Re: Copy n paste transformations

[ Edited ]

Hi, have you ever found a solution to your problem? I'd be quite interested to know the best way to proceed. Thanks

Super User
Posts: 5,257

Re: Copy n paste transformations

This thread is three years old. Crate a new thread with your own specific requirements and constraints.
Given the answers to the OP the answer is still no since there haven't been any developments on the sw in this area since then.
Data never sleeps
Ask a Question
Discussion stats
  • 5 replies
  • 543 views
  • 0 likes
  • 4 in conversation