tFileOutPutExcel Component cuts leading 0 in numbers

One Star

tFileOutPutExcel Component cuts leading 0 in numbers

example : I have 0,22 but in it is shown in excel as ,22.
How the problem could be resolved?
Thank you in advance for for your answer.
One Star

Re: tFileOutPutExcel Component cuts leading 0 in numbers

Could You post some more info on the job what it does what components are used in the flow. I created a test job loding csv file into Excel and all was well I had the leading 0.
One Star

Re: tFileOutPutExcel Component cuts leading 0 in numbers

certainly,
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)
One Star

Re: tFileOutPutExcel Component cuts leading 0 in numbers

certainly,
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)
One Star

Re: tFileOutPutExcel Component cuts leading 0 in numbers

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.
One Star

Re: tFileOutPutExcel Component cuts leading 0 in numbers

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.

Thank you for your hint with tLogRow. I have checked it, 0 is cut by tOracleInput. Unfortunately I failed to find how I can to avoid it. I found no settings by tOracleInput, that could be useful in this case.
One Star

Re: tFileOutPutExcel Component cuts leading 0 in numbers

You're welcome. Please post the setting You use in tOracleInput.
One Star

Re: tFileOutPutExcel Component cuts leading 0 in numbers

You're welcome. Please post the setting You use in tOracleInput.