https://community.qlik.com/t5/Talend-Studio/Processing-tbl-records-using-tLoop-tWhile-tFlowToIterate-Calling/m-p/2203143#M4584 Hi, <BR />I am working on one data integration project and I have already designed my Job Design. Using below steps: <BR />a. Select DelimitedFile ctrl and connect it to filter. <BR />b. Then it will have 2 controls good/bad records. <BR />c. Bad records will be routed to badfile.txt file. <BR />d. Good records (Not null for mandatory fields) -&gt; TMapFilter (for preparing record to pass to OOB). <BR />e. For Good records will have lookup values (domainname) check these in TMap. <BR />f. In TMap select the sequence ID value for SP_company_ins <BR />g. Set other values similarly. <BR />h. Pass these values to ?LoopingRecordsForOOB? ctrl. <BR />i. Call the ?SP_Company_InsCall? ctrl to execute the value. <BR />j. Then Commit the values. <BR />In this in step H I am expecting that tFlowToIterate will loop thru the records and it will have current values in scope/context. Then I can pass those to ?SP_Company_InsCall? ctrl and insert to DB table. Currently this process is not working and after H rcords r in rows object only. Pls let me know which control I should use to loop thru the records and process it further to Stored Procedure. <BR />I am attaching image of my job design. <BR /> <BR />Regards <BR />Pratik Sat, 16 Nov 2024 13:09:37 GMT Anonymous 2024-11-16T13:09:37Z https://community.qlik.com/t5/Talend-Studio/Processing-tbl-records-using-tLoop-tWhile-tFlowToIterate-Calling/m-p/2203143#M4584 Hi, <BR />I am working on one data integration project and I have already designed my Job Design. Using below steps: <BR />a. Select DelimitedFile ctrl and connect it to filter. <BR />b. Then it will have 2 controls good/bad records. <BR />c. Bad records will be routed to badfile.txt file. <BR />d. Good records (Not null for mandatory fields) -&gt; TMapFilter (for preparing record to pass to OOB). <BR />e. For Good records will have lookup values (domainname) check these in TMap. <BR />f. In TMap select the sequence ID value for SP_company_ins <BR />g. Set other values similarly. <BR />h. Pass these values to ?LoopingRecordsForOOB? ctrl. <BR />i. Call the ?SP_Company_InsCall? ctrl to execute the value. <BR />j. Then Commit the values. <BR />In this in step H I am expecting that tFlowToIterate will loop thru the records and it will have current values in scope/context. Then I can pass those to ?SP_Company_InsCall? ctrl and insert to DB table. Currently this process is not working and after H rcords r in rows object only. Pls let me know which control I should use to loop thru the records and process it further to Stored Procedure. <BR />I am attaching image of my job design. <BR /> <BR />Regards <BR />Pratik Sat, 16 Nov 2024 13:09:37 GMT https://community.qlik.com/t5/Talend-Studio/Processing-tbl-records-using-tLoop-tWhile-tFlowToIterate-Calling/m-p/2203143#M4584 Anonymous 2024-11-16T13:09:37Z