You are not logged in.

Unanswered posts

Important! This site has been replaced. All content here is read-only. Please visit our brand-new community at We look forward to hearing from you there!

#1 2016-06-02 10:59:11


hameed said:

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

Tags: [CSV file, perl]

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.

Hameed S.

#2 2016-06-03 04:24:10

Talend Team

xdshi said:

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

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

What we can do is to make sure that Talend will be your best choice!


#3 2016-06-23 13:49:03


hameed said:

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

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

Board footer

Talend Contributor Agreement - Talend Website Privacy Policy