At Stater we needed to iterate a table in a database and perform some action on it. This needed to be orchestrated from a workflow. In our case trigger a set of MP's and write the output to a DQ Data warehouse.
So I created a ‘pattern’ which we use for our cookbook. With thanks to Brian and Matej!
Now if somebody can tell me how to add a PDF and ZIP with the sample, I'd be happy ;)
Okay, so here is the PDF with the explanation and a sample in a ZIP.
The sample was created in 13.7.
Let us know if we could have done things differently. Thank you.
I have exact similar situation. following this solution and the tutorial sample 07_04_Iterator_SQL_Parent.ewf, I am following exactly same setting but somehow the parameters is not getting recognized . Please refer to following screenshots and help me find my mistake:
I am getting this error while trying run:
30.08.2023 10:39:07 [FATAL] The following variables are declared but not defined: process_date [Workflow]
I think that in the properties of the Run DQC you need to define the paramater with quotes. Am I correct I see a dollar-sign now? So the expression is "”"”+process_data+"”"”.
Thanks for the response , Ataccama provided sample plan has $ sign to read a parameter , I have tried with “”””+pocess_date+”””” as well but its not recognizing
Strange. The sample plan is mine. I'm sure you should have 4 opening and 4 closing double quotes. (But this editor is a bit strange with quotes.)
"”"”+var+"”"”. (Maybe take out the underscore. Atac is sometimes a bit strange with those?) But I also notice your var isn't pink/purple. When you created the name, was it selected from the drop-down? (CTRL-space dropdown) If not then it is not yet declared in the Global Properties of the workflow-canvas. Can you share the global properties of the canvas with the RunDQC?
yes that's true its not turning pink/purple , removing underscore doesn't help either., see nothing comes matching starting with ‘p’
I have both parent(iterator) and child (DQC) plans in same folder , I hope this is the correct referencing.
Can you share the global properties of the canvas to run the DQC? Click on a white space in the canvas (right-click) and 'edit properties’. Did you declare the input parameters?
Ah got it , I am able to pass parameter to child workflow and iterate it.
How do I edit actual plan/comp parameter mapping ? its blank and on right click its not allowing to add anything.
Hi, I think all that is in the PDF. You have to use the alter format and map the variables:
Yes , I am able to successfully do it. Many thanks
You are welcome!
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
