Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to iterate through 40+ SELECT statements currently held in an Excel spreadsheet..pass them to an OracleRow ....and output the results to another excel spreadsheet. Appending the results of each SQL statement to the end.
I currently have a job with a tFileInputExcel and tOracleRow component. I want to pass each SQL statement (held in one column in one sheet) into the query of the tOracleRow.
Any guidance would be great. I think I need a parameter / variable just cant see how to set it all up.
Regards,
Michelle
I want to iterate through 40+ SELECT statements currently held in an Excel spreadsheet..pass them to an OracleRow ....and output the results to another excel spreadsheet. Appending the results of each SQL statement to the end.
I currently have a job with a tFileInputExcel and tOracleRow component. I want to pass each SQL statement (held in one column in one sheet) into the query of the tOracleRow.
Any guidance would be great. I think I need a parameter / variable just cant see how to set it all up.
Regards,
Michelle
Hi,
For your use case, you use TalendHelpCenter:tContextLoad component to achieve that.
To make it clear, I have designed a demo job for you.
The workflow should be: tfixedflow(tfileinputxxx)-->tcontextload-->oncomponentOk-->tMysqlinput-->tfileoutputxxx
Please see my screenshots for details
Best regards
Sabrina
For your use case, you use TalendHelpCenter:tContextLoad component to achieve that.
To make it clear, I have designed a demo job for you.
The workflow should be: tfixedflow(tfileinputxxx)-->tcontextload-->oncomponentOk-->tMysqlinput-->tfileoutputxxx
Please see my screenshots for details
Best regards
Sabrina
How about this?
See the screenshots... The tJava is just a way to expose the row so you can use it in tOracle... And the schema of the Excel Spreadsheet is a single column named 'SQLScript' which holds the text of the SQL query from every row in the spreadsheet.
See the screenshots... The tJava is just a way to expose the row so you can use it in tOracle... And the schema of the Excel Spreadsheet is a single column named 'SQLScript' which holds the text of the SQL query from every row in the spreadsheet.