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

[_AnonymousUser]

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.

[Anonymous · Accepted solution]

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

[_AnonymousUser]

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