Modify user manager when uploading csv files

[JPMac]

We create users by uploading csv files.
In csv files, the initials of username in the manager attribute and username registered in Saviynt are different.As I will explain using a simple csv file, in the following case, the username of manager starts with 'L', while the username of Manager registered in Saviynt starts with 'M'.

Therefore, in the SAV file when uploading CSV, I created the character of manager attribute of NEWUSERDATA to be converted from "L" to "M."

*I attach the sav files

However, this does not include manager attribute. Could you please advise if there is any mistake in writing SAV file?

[AmitM]

Hi @JPMac ,

"UPDATE NEWUSERDATA SET NEWUSERDATA.MANAGER = REPLACE(NEWUSERDATA.MANAGER,'L','M')"

You don't need current users table in this.

Thanks,

Amit

If helped, consider ACCEPTING SOLUTION

[rushikeshvartak]

Remove # ( comment) before MODIFYUSERJSON keyword