Preprocessor query to concat user's firstname and lastname and send it as a single field

[Debankita]

Hi Team,

Can someone please help me with the preprocessor query by which I can concatenate user's firstname and lastname and send it as a single field in a customproperty.

Thanks in Advance,

[DixshantValecha]

Hi Debankita,

Kindly refer to the enclosed document for comprehensive details regarding your requirement.

The document can be accessed at the following link: https://docs.saviyntcloud.com/bundle/KBAs/page/Content/Integration-Options-with-the-Saviynt-Database...

If you require any further information or assistance, please let us know.

[dgandhi]

Hi,

We used below 

{ "ADDITIONALTABLES": {
"USERS": "SELECT FIRSTNAME, LASTNAME, customproperty22, customproperty23 FROM USERS"
},
"COMPUTEDCOLUMNS": [
"customproperty25"
],
"PREPROCESSQUERIES": [
"UPDATE NEWUSERDATA SET customproperty25 = (case when (firstname is not null and CUSTOMPROPERTY23 is not null) then CONCAT(CUSTOMPROPERTY23,',',' ',firstname) when (firstname is null and CUSTOMPROPERTY23 is not null) then CONCAT(CUSTOMPROPERTY23,',',' ',customproperty22) when (firstname is not null and CUSTOMPROPERTY23 is null) then CONCAT(lastname,',',' ',firstname) when (firstname is null and CUSTOMPROPERTY23 is null) then CONCAT(lastname,',',' ',customproperty22) END)"
]
}

Thanks