Context Variables During Execution

Anonymous — Fri, 21 Sep 2018 00:25:21 GMT

Hey - I'm trying to achieve something clever with context variables and a tMysqlOutput component. I have a database that contains 60+ tables and I'm trying to build out a dynamic job that lists the tables with a simple SHOW TABLES command into a delimited file. I then read that file and run it through an iterate flow to allow me to set a context.TableName variable in the flow. I have a single tMysqlOutput component and want the Table to be defined by the value of the context.TableName. So, this transformation in the MySQL component needs to happen during the flow.

However, I have a suspicion the context.TableName will be transformed at compilation time as when I run the job it complains that the Table in the component is not set.

Any help would be great!

Re: Context Variables During Execution

Anonymous — Fri, 21 Sep 2018 06:05:16 GMT

Hi,

Your query is similar to one another query I answered yesterday. Could you please refer the beow link and let us know whether it helped to clarify your query?

https://community.talend.com/t5/Design-and-Development/Design-Job-for-Redshift/m-p/134678#M83958

If the reply has helped you, could you please mark the topic as resolved? Kudos are also welcome.

Warm Regards,

Nikhil Thampi

topic Re: Context Variables During Execution in Talend Studio

Context Variables During Execution

Re: Context Variables During Execution