Preprocessor Query with same data set with different location

[lakshman]

Dear team, I have a preprocessor set up in the following format. However, when importing dataset values with the same name as custompropert15 and 16, it should display "India" as the country name. Although the country name is India, the locations should be different. How can I write a preprocessor query to achieve this? Additionally, how can I concatenate one country into different locations?

[

"UPDATE NEWUSERDATA LEFT JOIN CURRENTUSERS ON NEWUSERDATA.CUSTOMPROPERTY1=CURRENTUSERS.CUSTOMPROPERTY1 SET NEWUSERDATA.customproperty16 = (select attribute2 from CURRENTDATASET_VALUES where datasetname = 'Country Location Mapping' and attribute1 = NEWUSERDATA.customproperty15)"

]

[Raghu]

@lakshman  you want anyway hardcode value india of att2 to cp16, directly you update like below

UPDATE NEWUSERDATA
LEFT JOIN CURRENTUSERS ON NEWUSERDATA.CUSTOMPROPERTY1 = CURRENTUSERS.CUSTOMPROPERTY1
SET NEWUSERDATA.customproperty16 = (
SELECT attribute2
FROM CURRENTDATASET_VALUES
WHERE datasetname = 'Country Location Mapping'
AND attribute1 = 'India'
)

[rushikeshvartak]

Refer https://forums.saviynt.com/t5/identity-governance/concatenate-the-attribute-values-in-a-dataset-usin...