topic Re: Split tOracleRow output to multiple output files in Talend Studio

Split tOracleRow output to multiple output files

Anonymous — Fri, 16 Nov 2018 14:33:46 GMT

Hello,

my workflow is as follows. I have an input text file with just one column (rows contain some number as customer IDs). For each ID I need to execute a prepared statement and output of this statement should be saved into a separate file named customer_id_some_fixed_text.txt.

My "train" is tFileInputDelimited => tJavaRow => tOracleRow => tParseRecordset => tFileOutput[whatever] (output format is not that important).

In the tJavaRow (besides the generated code) I'm just setting a context variable

context.vCurCustId = input_row.CUST_ID;

tOracleRow is executing a simple statement like

"select * from my_customers where customer_id = ?"

parameters and everything else is set correctly and here I would like to create an output file named context.vCurCustId + "some_other_text.txt".

The problem is that the entire output (for all customer_ids) goes into one file and I have no idea what I'm missing.

Any suggestions would be highly appreciated.

Thanks a lot,

Pavel

Re: Split tOracleRow output to multiple output files

TRF — Fri, 16 Nov 2018 15:15:50 GMT

You cannot change the output filename during the flow execution.

So, you have to introduction a tFlowToIterate + a tIterateToFlow.

As you'l have a new flow for each record, now you can change the filename.

Re: Split tOracleRow output to multiple output files

Anonymous — Sat, 17 Nov 2018 00:10:26 GMT

Hi TRF,

thank you very much for your response, however I must admit that I have absolutely no experience with these two controls. Please, could you be a bit more specific where exactly I am supposed to place them and how to set them up properly?

Regards,

Pavel