Saviynt Pre-processor for dataset

[Shubhamjain27]

Hi Everyone,

We have a requirement where we have 2 datasets

Dataset 1 contains mapping between location and location ID

Dataset 2 contains mapping between location ID and cost center

From workday we are getting location and we need to use Dataset1 to get the location ID and later dataset 2 to get the cost center based on the location ID we got from the first dataset.

We can have 2 comma separated questions to update newuserdata. But can anyone confirm if its possible to use data we got from dataset1 to dataset2

For example:

update newuserdata set customproperty5 = (select attribute2 from CURRENTDATASET_VALUES where datasetname = 'Locationdata' and attribute1 = NEWUSERDATA.location),

update newuserdata set customproperty6 = (select attribute2 from CURRENTDATASET_VALUES where datasetname = 'costcenter' and attribute1 = NEWUSERDATA.customproperty5)

Please confirm if its possible?

[rushikeshvartak]

You can use dataset

https://forums.saviynt.com/t5/identity-governance/dataset-usage-in-user-import-preprocessor/m-p/5599...

[Shubhamjain27]

Dataset I am using anyways,

the question is:

Can we use dataset 1 to get one value and then query dataset 2 with the value we get from dataset1.

Is it possible with the query I provided in the description.

[rushikeshvartak]

Yes