Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

Saviynt Pre-processor for dataset

Shubhamjain27
New Contributor
New Contributor

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?

3 REPLIES 3

rushikeshvartak
All-Star
All-Star

You can use dataset

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


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

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.

Yes


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.