Hi All, I am new to Matillion and am trying to use Job variable which I can dynamically update in the orchestration job and want to use that value in transformation job. Is this possible, if so can someone please explain how to do it?

Matillion ETL
1

I defined a job variable in both Orchestration and Transformation jobs. I am dynamically changing the value through python Script in Orchestration.

 

I am calling a transformation job from this same Orchestration and want to pass the updated value. Is there any way how I can pass on this updated value, which will change on every run.

 

 

2

Welcome to the Community, @srikar.yeleswarapu​

@Michael​, this might be up your alley. Think you can give @srikar.yeleswarapu​ a hand? Thanks in advance.

Cheers!

Chika

3

Hi @srikar.yeleswarapu​ ,

you already have 90% of this done! The missing bit is actually passing the variable to the Transformation job. In the Orchestration job, look for the (green) Component with your transformation job. There, edit "Set Scalar Variables" and choese the Transformation job variable on the left side. Then enter ${your_orchestration_var} on the right side. Example:

0694G00000Jlnx4QAB_0D74G000007kpOsSAI
0694G00000Jlnx4QAB_0D74G000007kpOsSAI765×508 13.8 KB

4

Thank you so much Michael !!