Hello all. I have searched the forums for an answer to this and have not found exactly what I need.
I have two fields that I want to combine to make a third. I have successfully accomplished this in the data load editor using the concatenate function as follows:
"OS_VERSION", CONCAT("OS_NAME", "OS_VERSION") AS "OS_FULL",
Of course, this results in the fields appearing without a space between them. When I try using SQL syntax to add a space, I get an error upon loading the data. I have tried the following to no avail:
"OS_VERSION", CONCAT("OS_NAME", " ", "OS_VERSION") AS "OS_FULL", (results in error)
"OS_VERSION", CONCAT("OS_NAME", ' ', "OS_VERSION") AS "OS_FULL", (results in error)
"OS_VERSION", CONCAT("OS_NAME" & & "OS_VERSION") AS "OS_FULL", (results in error)
