Data360 Analyze

Welcome to the Data360 Analyze community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Here are some useful links where you can find more information:

Product Announcements  Product Documentation  Ideas Portal

Discussions

Members

Resources

Events

 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!!