This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have columns with double datatype and when rendered into .xlsx output file a few numbers are dispalayed as text.( small green triangle at the left top corner of the cell)
Whats the issue.How can this be corrected.
@PoojaSingh88 can you share the workflow for us?
its a large workflow and cant be shared due to data confidentiality rules.
However I can share few examples of what's happening
when I check the browse for the column 1 which is configured as a double - I can see the value as per below
when I use the table tool -> Layout -> render tool to output this in .xlsx I see the output as -917,730 but as a text format a green triangle on left top corner of the cell.
Also to note I have read these via a binary input file and am writing it to xlsx.
The Render tool effectively creates the table as a blob type this is why the formatting defaults to Text (V_WString).
Double does not support Blobs.
Is there a way you can output the columns directly using the Output tool?
I need to use render tool as formatting is required in the output report ...what other data type can I use that would support the number format in the render tool ?
What does the number represent in your data?
I came across this post
Here the output appears in Excel as a Custom/Currency/Special format.
Maybe this will help you in some way?
I still am facing issues.
Now I am reading the input files in .xlsx format. processing data all in double datatype and outputting to a .xlsx file using the render tool.
A few negative large numbers are being written as text and not numbers. This is causing issues to validate.
Any help would be appreciated.