While doing user import - Can we refer multiple datasets in preprocess (MODIFYUSERDATAJSON)

[IAM_99]

Hi Team,

Can we refer multiple dataset for user profile attribute transformations ?

"DATASET_VALUES": "SELECT ATTRIBUTE1 FROM DATASET_VALUES

"DATASET_VALUES_OTHER": "SELECT ATTRIBUTE1 FROM DATASET_VALUES

Thanks,

[Rajesh-R]

@IAM_99 - Yes you can refer to multiple datasets.

[Manu269]

@IAM_99 yes we have the feassibility to use.

Note :

Can you use the upper case while using datasets

[IAM_99]

Thanks @Rajesh-R @Manu269  for the response.

Could you share sample for this if possibile ?

[IAM_99]

 Hello @rajesh-ram @Manu269 

Can you share sample - how multiple datasets look like ?

[rushikeshvartak]

{
"ADDITIONALTABLES": {

"DATASET_VALUES": "SELECT ATTRIBUTE1 FROM DATASET_VALUES"

"DATASET_VALUES1": "SELECT ATTRIBUTE1 FROM DATASET_VALUES"

}

...
}

[IAM_99]

thanks for the response.

Will Saviynt understood this automatically ?

"TABLEINDEXES": {
"CURRENTUSERS": [
"USERNAME"
],
"NEWUSERDATA": [
"USERNAME"
],
"CURRENTDATASET_VALUES": [
"ATTRIBUTE1"
],
"CURRENTDATASET_VALUES1": [
"ATTRIBUTE1"
],

},

[rushikeshvartak]

Ideally yes cna you try and let us know outcome

[rushikeshvartak]

@IAM_99  Did it worked for you?

[IAM_99]

Sorry lost track on this it didnt work.

[rushikeshvartak]

Never mind its working i have tested

https://forums.saviynt.com/t5/identity-governance/same-table-multiple-times-in-pre-processor/td-p/80...