How to loop through the contents in a csv file

[Ravi_Rajagopal]

Hi

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​

[vikramk]

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.

[David_Beaty]

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

[Ravi_Rajagopal]

@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.

[vikramk]

Hi @Ravichandran Rajagopal​ ,

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