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

Highlighted
One Star

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

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.


Accepted Solutions
Moderator

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

All Replies
Moderator

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

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

Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch