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:
Sent: 05-09-2024 04:49
From: andrew darnell
Subject: Combine Multiple Columns into 1
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
------------------------------