https://community.qlik.com/t5/Talend-Studio/Context-Variable-in-tMysqlOutput/m-p/2342050#M109953 <P>Is it possible to use a Context Variable in a <STRONG>tMysqlOutput </STRONG>component's "Table" field?<BR /><BR />Ctrl+Space seems to suggest so...<BR /><BR /><span class="lia-inline-image-display-wrapper" image-alt="0683p000009MFjl.jpg"><img src="https://community.qlik.com/t5/image/serverpage/image-id/128645i519939CDC138B4D2/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MFjl.jpg" alt="0683p000009MFjl.jpg" /></span><BR /><BR /><BR /><STRONG>context.tableprefix</STRONG>&nbsp;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.<BR /><BR /><span class="lia-inline-image-display-wrapper" image-alt="0683p000009MFgQ.jpg"><img src="https://community.qlik.com/t5/image/serverpage/image-id/130869i5B102A9AD17854B0/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MFgQ.jpg" alt="0683p000009MFgQ.jpg" /></span><BR /><BR />I have specified this in my<STRONG> tJavaRow</STRONG> and asked it to print the variable to the run window, so I can check it is working - which it is.<BR />It seems like it just doesn't get recognised in <STRONG>tMysqlRow</STRONG> though, evident from the <FONT color="#ff3333">Incorrect table name ""</FONT> error.<BR /><BR /><BR />I have had this method working with a <STRONG>tMysqlRow </STRONG>component, but it runs too slowly (2000 rows/s)</P> Wed, 14 Sep 2016 09:51:57 GMT cjj 2016-09-14T09:51:57Z https://community.qlik.com/t5/Talend-Studio/Context-Variable-in-tMysqlOutput/m-p/2342050#M109953 <P>Is it possible to use a Context Variable in a <STRONG>tMysqlOutput </STRONG>component's "Table" field?<BR /><BR />Ctrl+Space seems to suggest so...<BR /><BR /><span class="lia-inline-image-display-wrapper" image-alt="0683p000009MFjl.jpg"><img src="https://community.qlik.com/t5/image/serverpage/image-id/128645i519939CDC138B4D2/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MFjl.jpg" alt="0683p000009MFjl.jpg" /></span><BR /><BR /><BR /><STRONG>context.tableprefix</STRONG>&nbsp;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.<BR /><BR /><span class="lia-inline-image-display-wrapper" image-alt="0683p000009MFgQ.jpg"><img src="https://community.qlik.com/t5/image/serverpage/image-id/130869i5B102A9AD17854B0/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MFgQ.jpg" alt="0683p000009MFgQ.jpg" /></span><BR /><BR />I have specified this in my<STRONG> tJavaRow</STRONG> and asked it to print the variable to the run window, so I can check it is working - which it is.<BR />It seems like it just doesn't get recognised in <STRONG>tMysqlRow</STRONG> though, evident from the <FONT color="#ff3333">Incorrect table name ""</FONT> error.<BR /><BR /><BR />I have had this method working with a <STRONG>tMysqlRow </STRONG>component, but it runs too slowly (2000 rows/s)</P> Wed, 14 Sep 2016 09:51:57 GMT https://community.qlik.com/t5/Talend-Studio/Context-Variable-in-tMysqlOutput/m-p/2342050#M109953 cjj 2016-09-14T09:51:57Z https://community.qlik.com/t5/Talend-Studio/Context-Variable-in-tMysqlOutput/m-p/2342051#M109954 Hi,<BR />Here is a <A href="https://help.talend.com/search/all?query=tCreateTable" target="_blank" rel="nofollow noopener noreferrer">TalendHelpCenter:tCreateTable</A> component which is used to create and drop the specified table.<BR />Have you tried to use this component to dynamically control the table name you are inserting data into on your MySQL DB?<BR />Best regards<BR />Sabrina Mon, 19 Sep 2016 05:50:48 GMT https://community.qlik.com/t5/Talend-Studio/Context-Variable-in-tMysqlOutput/m-p/2342051#M109954 Anonymous 2016-09-19T05:50:48Z