Skip to main content
Hello

 

 

I created a workflow that transforms some data. As I have to do the same transformation for various oracle-users, I'm using the workflow-runner in a second workbench.

 

But it's not only the name of the user, that I need to pass to the transformation-workflow, but also a second parameter (an attribute in a table).

 

I read in a post, that I have to concatenate the two values an pass them as one parameter to the other workflow.

 

 

But how can I integrate that parameter in my workflow? There is a transformer "parameter-fetcher", but it needs input from a reader.

 

I also have to split the parameter again (Attribute-splitter) and use one of the two parameters for my reader (oracle-user) and the other in my writer (attribute).

 

 

Thanks in advance

 

Vera
Hi Vera,

 

 

I don't think you have to concatenate those two parameters. You can pass those parameters simultaneously through the WorkspaceRunner if you publish the second parameter in the first workspace. You can also pass an attribute value read from a table through the WorkspaceRunner.

 

 

Takashi
Thanks Takashi

 

 

I got it working now. I wrote my parameters in a csv-File instead of an txt-File, which I split, and could pass them to the other workspace.

 

 

Vera

Reply