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  

3 REPLIES
Twelve 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
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.