Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
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