Require inputs on preprocessing script to fetch data from Workday

[sairamya15]

Hi All,

We have below requirements to pull users data from Workday(Auth source). 

1 It should remove the suffixes from the Last Name (ex: Jr, Sr, jr, sr)

2. if the middle name is provided is single letter it should made capital and concat with "."  , if it is a word then 1st letter should be capital letter followed with small letters.

We need the preprocess script for to fetch the data, kindly assist if anyone has worked on similar scenario.

[rushikeshvartak]

{
    "ADDITIONALTABLES": {
        "USERS": "SELECT USERNAME,FIRSTNAME,LASTNAME FROM USERS"
    },
    "COMPUTEDCOLUMNS": 
	[ 	"USERNAME"
	],
    "PREPROCESSQUERIES": ["UPDATE NEWUSERDATA SET NEWUSERDATA.lastname = REGEXP_REPLACE(NEWUSERDATA.lastname, '(^MR.|JR.|Sr.|II|IV|X)(s|$)', ' ')"
    ]
}

[sairamya15]

Hi @rushikeshvartak 

Thanks for the response.

Any suggestions for the Middle Name.