Data360 Analyze

 View Only

  • 1.  format a number of type double with specific format

    Employee
    Posted 02-17-2020 20:30

    Hi guys, how to format a number of type double with "thousand separator of Comma" and "2 decimal places"? use "modify field" node or others? modify field node, about double type, no options for format.  thanks.



  • 2.  RE: format a number of type double with specific format

    Employee
    Posted 02-19-2020 14:08

    You can use the Format attribute within the OutputFields grid to format a string value. In this case the Format attribute would be set to  %,.2f   

    In this example that uses the Modify Fields node, the input 'Data' field (which is a double type) is converted to a string and is renamed to 'formattedValue'. The conversion includes the thousand separator and sets the precision to two digits

    See the node Help for further information on formatting.

    If you want to perform a similar conversion in the Transform node then the following example shows how to output a new field containing the formatted string:

     



  • 3.  RE: format a number of type double with specific format

    Employee
    Posted 02-20-2020 03:05

    thanks a lot!!