topic Re: [resolved] How to Iterate the Records from EXCEL in Talend in Talend Studio

[resolved] How to Iterate the Records from EXCEL in Talend

_AnonymousUser — Thu, 02 Jun 2016 10:59:11 GMT

Hi Folks,

I got an New Requirement where I will the Records in Single Column in a File. I would like to Extract the data in such a way that the Column Length should be greater than 255 Character's. After Picking the data again I need to split the Total String into 5-Different Field's the logic for each Field extraction is given below.

Field1 = trim(substr(5,8));
Field2 = trim(substr(13,40));
Field3 = trim(substr(53,40));
Field4 = trim(substr(93,40));
Field5 = trim(substr(133,5));

I have Tried tFlowToIterate Component to send the Recod's One By One, But am just messed up in Checking the Length's and getting the above logic done for
all the Records in the File. Kindly provide your feedback's on this.

Thanks,
Hameed S.

Re: [resolved] How to Iterate the Records from EXCEL in Talend

Anonymous — Fri, 03 Jun 2016 04:24:10 GMT

Hi,
Here is a component TalendHelpCenter:tFlowToIterate which is used to iterate on the input data and generates global variables.
Please take a look at component reference with a scenario.
Best regards
Sabrina

Re: [resolved] How to Iterate the Records from EXCEL in Talend

_AnonymousUser — Thu, 23 Jun 2016 13:49:03 GMT

Thanks Sabrina For your quick reply.
I have Used the tFlowToIterate Component as per ur suggestion's to Iterate the Records one by one.
Thanks for your Help