topic Re: Numerical data reading from the Excel sheet in Talend Studio

Numerical data reading from the Excel sheet

Anonymous — Wed, 21 Mar 2018 06:56:49 GMT

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

Re: Numerical data reading from the Excel sheet

manodwhb — Wed, 21 Mar 2018 07:09:56 GMT

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

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

Re: Numerical data reading from the Excel sheet

Anonymous — Wed, 21 Mar 2018 07:14:43 GMT

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.

Re: Numerical data reading from the Excel sheet

Anonymous — Wed, 21 Mar 2018 07:24:25 GMT

Hello Mastanaiah Shaik,

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

Best regards

Sabrina