Context Variables During Execution

[Anonymous]

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!

[Anonymous · Accepted solution]

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