topic Re: tFileOutPutExcel Component cuts leading 0 in numbers in Talend Studio

tFileOutPutExcel Component cuts leading 0 in numbers

_AnonymousUser — Sat, 16 Nov 2024 12:42:55 GMT

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.

Re: tFileOutPutExcel Component cuts leading 0 in numbers

Anonymous — Mon, 29 Aug 2011 11:39:48 GMT

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.

Re: tFileOutPutExcel Component cuts leading 0 in numbers

_AnonymousUser — Mon, 29 Aug 2011 12:10:12 GMT

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)

Re: tFileOutPutExcel Component cuts leading 0 in numbers

Anonymous — Mon, 29 Aug 2011 12:27:02 GMT

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)

Re: tFileOutPutExcel Component cuts leading 0 in numbers

Anonymous — Mon, 29 Aug 2011 14:02:36 GMT

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.

Re: tFileOutPutExcel Component cuts leading 0 in numbers

Anonymous — Mon, 29 Aug 2011 14:45:32 GMT

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.

Re: tFileOutPutExcel Component cuts leading 0 in numbers

Anonymous — Mon, 29 Aug 2011 15:04:15 GMT

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

Re: tFileOutPutExcel Component cuts leading 0 in numbers

Anonymous — Mon, 29 Aug 2011 15:11:07 GMT

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