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 https://community.talend.com/. We look forward to hearing from you there!



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

hameed
Guest

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.

Thanks,
Hameed S.

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

xdshi
Talend Team


xdshi said:

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

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


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

Offline

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

hameed
Guest

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