topic Re: How to loop through the contents in a csv file in Talend Studio

How to loop through the contents in a csv file

Ravi_Rajagopal — Sat, 16 Nov 2024 01:11:51 GMT

I have a csv file I have to do the following:

1. Read the csv file - I can use tFileInputDelimited

2. Write the records to a working storage table - I can use tMap and then call tOracleOutput

3. Call a stored procedure which will validate all the data in the working storage table and then write the same to the official table and delete the record from the working storage table - I can use tDBsp.

I don't know how to repeat steps 1 through 3 till all the records in the csv file are completely processed.

Please advise.

Thanks and regards

Ravi Rajagopal

Re: How to loop through the contents in a csv file

vikramk — Sun, 01 Nov 2020 14:25:01 GMT

Hi @Ravichandran Rajagopal ,

Would you mind elaborating this - "I don't know how to repeat steps 1 through 3 till all the records in the csv file are completely processed." Do you mean that you have multiple sheets in file or unstructured data in file. what do you want to achieve by repeating the steps. Because I don't see any necessity to repeat the steps.

Re: How to loop through the contents in a csv file

David_Beaty — Mon, 02 Nov 2020 08:25:58 GMT

Hi,

Using the Oracle stored procedure hides some of the functionality of your data flow, which you should avoid at all costs. You should really consider doing the whole thing within Talend rather than switching from Talend to the Oracle SP then back to Talend.

Thanks

David

Re: How to loop through the contents in a csv file

Ravi_Rajagopal — Fri, 06 Nov 2020 03:20:00 GMT

@Vikram Kumar

Hi thanks for responding. I have copy/pasted the entire question in a word document and have attached along with this thread. Would you mind taking a look at the same and responding back with your suggestions please.

Re: How to loop through the contents in a csv file

vikramk — Fri, 06 Nov 2020 05:17:13 GMT

Hi @Ravichandran Rajagopal ,

Looks like file is corrupted, I'm not able to open the file. Could you check once.