Numerical data reading from the Excel sheet

Five Stars

Numerical data reading from the Excel sheet

 hi,

i am new to Talend, I am using Talend open studio for big data. i am dealing with the task which contains a excel file having rows data with numbers and strings i want to read only the numeric data from the file and want to print in a table format. can you please help me how to do this. can you please send me the detailed job design.

 

Thanks & Regards

Mastanaiah Shaik  

Forteen Stars

Re: Numerical data reading from the Excel sheet

@Mastan_123,read in below way,since in tmap you can pass therequired fileds to output section.

 

tFileInputExcel-->tMap-->tLog(select Table format)

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Five Stars

Re: Numerical data reading from the Excel sheet

My Excel file contain "Minimum: 8.08, Maximum: 8.13, Average: 8.10, Standard Dev.: 0.02, Reletive Std. Dev.: 0.23", "191.0 mg Ñ 3.0% (Between 185.27 mg to 196.73 mg)" this type of data from this i want only the numeric data to be propagated to next component.

Moderator

Re: Numerical data reading from the Excel sheet

Hello Mastanaiah Shaik,

Could you please elaborate your case with an example with input and expected output values?

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.

What’s New for Talend Spring ’19

Join us live for a sneak peek!

Sign up now

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads