Context Variable in tMysqlOutput

[cjj]

Is it possible to use a Context Variable in a tMysqlOutput component's "Table" field?

Ctrl+Space seems to suggest so...




context.tableprefix is the context variable in question, the value of which I want to use to dynamically control the table name I am inserting data into on my MySQL DB.



I have specified this in my tJavaRow and asked it to print the variable to the run window, so I can check it is working - which it is.
It seems like it just doesn't get recognised in tMysqlRow though, evident from the Incorrect table name "" error.


I have had this method working with a tMysqlRow component, but it runs too slowly (2000 rows/s)

[Anonymous]

Hi,
Here is a TalendHelpCenter:tCreateTable component which is used to create and drop the specified table.
Have you tried to use this component to dynamically control the table name you are inserting data into on your MySQL DB?
Best regards
Sabrina