# 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?

**URL:** <https://matillioncommunity.discourse.group/t/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/1683>\
**Category:** Matillion ETL\
**Created:** [March 7, 2022, 5:50am UTC](https://matillioncommunity.discourse.group/t/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/1683 "2022-03-07T05:50:32Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![srikar.yeleswarapu](https://avatars.discourse-cdn.com/v4/letter/s/5f8ce5/32.png) [@srikar.yeleswarapu](https://matillioncommunity.discourse.group/u/srikar.yeleswarapu)\
**Post date:** [March 7, 2022, 5:50am UTC](https://matillioncommunity.discourse.group/t/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/1683/1 "2022-03-07T05:50:32Z")

</div>

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

&nbsp;

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.

&nbsp;

&nbsp;

---

<div class="post-metadata">

**Author:** ![ChikaMatillionCommunityMgr](https://avatars.discourse-cdn.com/v4/letter/c/c5a1d2/32.png) [@ChikaMatillionCommunityMgr](https://matillioncommunity.discourse.group/u/ChikaMatillionCommunityMgr)\
**Post date:** [March 7, 2022, 6:43pm UTC](https://matillioncommunity.discourse.group/t/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/1683/2 "2022-03-07T18:43:16Z")

</div>

Welcome to the Community, [@srikar.yeleswarapu](https://matillioncommunity.discourse.group/u/srikar.yeleswarapu)​

[@Michael](https://matillioncommunity.discourse.group/u/Michael)​, this might be up your alley. Think you can give [@srikar.yeleswarapu](https://matillioncommunity.discourse.group/u/srikar.yeleswarapu)​ a hand? Thanks in advance.

Cheers!

Chika

---

<div class="post-metadata">

**Author:** ![Michael](https://avatars.discourse-cdn.com/v4/letter/m/4bbf92/32.png) [@Michael](https://matillioncommunity.discourse.group/u/Michael)\
**Post date:** [March 8, 2022, 7:16am UTC](https://matillioncommunity.discourse.group/t/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/1683/3 "2022-03-08T07:16:12Z")

</div>

Hi [@srikar.yeleswarapu](https://matillioncommunity.discourse.group/u/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](https://us1.discourse-cdn.com/flex002/uploads/matillioncommunity/original/1X/974a4d7ec0a41614d7b693beb3d8777c906c4564.png)

---

<div class="post-metadata">

**Author:** ![srikar.yeleswarapu](https://avatars.discourse-cdn.com/v4/letter/s/5f8ce5/32.png) [@srikar.yeleswarapu](https://matillioncommunity.discourse.group/u/srikar.yeleswarapu)\
**Post date:** [March 10, 2022, 10:17am UTC](https://matillioncommunity.discourse.group/t/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/1683/4 "2022-03-10T10:17:30Z")

</div>

Thank you so much Michael !!
