Pentaho Data Integration : Microsoft Excel Input

Microsoft Excel Input step can be used to integrate data from various Excel sources including open office work books. This step can extract data from Excel 97-2003 ( xls ) files or Excel 2007 ( xlsx ) files.  Plz find stepwise illustration below on how to configure Pentaho Excel Input Step.
 

Step 1

Drag and drop Microsoft Excel Input Step into the Transformation design canvas.


Step 2

Click on Browse to select local Excel file with sample data.


Step 3

Add the selected file.
Also there are options available to add list of files or to specify wild cards.
File names can be retrieved from previous steps using "Accept Filenames from previous steps" option.


 
Step 4

Click on the Sheets tab to select list of sheets to read from.
"Get sheetnames" button will retrieve a list of available worksheets.
Select from the available items.

 














Step 5

Click on content tab to manage content properties.
Following are some of the commonly used options.

Header                      - First row will be skipped as header row.
No Empty Rows       - Empty rows will be skipped.
Stop on Empty Row - Step will stop in case of any empty row.
Limit                         - Limit the number of rows. Enter 0 to process all rows.



Step 6

Click on Fields tab to generate and configure fields.
Use "Get fields from header row" button to export field names and attributes from sample data file sheet header row. Name and other attributes can be modified based on the requirements.
Following are some of the commonly used options.

Name         - Field name.
Type          - Data type.
Trim Type - Support left, right and both trim.
Repeat       - Default is N. Set to Y to repeat the value in case next field is empty.



 
Step 7

Additional output fields can be configured if needed.


 

Step 8

Click on "Preview rows" button to examine the data.
 
 

3 comments :

oracle fusion said...

Hi, I am really happy to found such a helpful and fascinating post that is written in well manner. Thanks for sharing such an informative post.For more details about oracle fusion financial please check our website.

Oracle Fusion Financial Training Institute

oracle fusion hcm online Training said...

Oracle fusion financials online training institute we have our branch over all the india.
Oracle Fusion Cloud HCM Online Training in Hyderabad, Bangalore, Delhi, Chennai, Kolkata, Pune,
Mumbai, Ahmedabad, Gurgon, Noida, India, Dubai, UAE, USA, Kuwait, UK, Singapore, Saudi Arabia,
Canada, Oracle Fusion HCM Online Trainings
oracle fusion financials training
oracle fusion financials online training
oracle fusion Procurement training training
oracle fusion procurement online training



calfre services said...

his site has lots of advantage awesome i really enjoyed reading thanks for sharing for grate info ..we are also provide Save Time & Money with the all new local calfre search engine! this search engine can track all educational training institutes websites data,can find mobile numbers,everything just type one realated to ur course keyword ...java training

Post a Comment

UA-46724997-1