The Definitive Guide to Data Quality
the job reads tha data from Oracle DB (tOracleInput) and data are sent to tFileOutPutExcel.
Between both component the same schema is used. The column that I mean is defined as Number
The value comes from Oracle as 0.22 and is shown in excel as .22 (without leading zero)
Ok so the Number data type definition is the same as Numeric in PostgreSQL which I use. I have exported the data from table containing one row with values 0.22, 0.22 and the result was correct in Excel. I have used Advanced separator in Advanced settings of tFileOutputExcel component leaving the default settings, encoding was set to ISO-8859-15. I'm using TOS 4.2. I'd go with Excel cell formatting.
Try doing one more thing:add tLogRow component between tOracleInput and tFileOuputExcel see what are 'raw' data that are retrieved by the component. Then You will know wether the 0 is cut while creting the XLS file or by the OracleInput.