Data360 Analyze

 View Only

  • 1.  Combine Multiple Columns into 1

    Posted 11 days ago

    Hey Guys

    I am hoping that someone can tell me what expression to use to combine multiple columns using the Calculate node



    ------------------------------
    andrew darnell
    Knowledge Community Shared Account
    ------------------------------


  • 2.  RE: Combine Multiple Columns into 1

    Employee
    Posted 11 days ago

    The expressions used in the Calculate Fields node are Python statements. You can concatenate them as strings using the '+' operator. However, the fields need to be first converted to strings if they are a different data type. The Calculate Fields node provides options for the default value to be used for a Null value (see the node Help documentation). Here is an example of concatenating a few fields with a delimiter between the values.



    ------------------------------
    Adrian Williams
    Precisely Software Inc.
    ------------------------------

    Original Message