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

can we put conditions inside inline preprocessor -PREPROCESSQUERIES ( User Import)

IAM_99
Regular Contributor II
Regular Contributor II

Hi Team,

Can we put a conditional  updates  in the  "PREPROCESSQUERIES": [

for example : 

"PREPROCESSQUERIES": [

if cp65 = India 

{"UPDATE NEWUSERDATA NU INNER JOIN CURRENTACCOUNTS .....",

"UPDATE NEWUSERDATA NU LEFT JOIN CURRENTUSERS"}

if cp65= USA

{"UPDATE NEWUSERDATA NU INNER JOIN CURRENTACCOUNTS .....",

"UPDATE NEWUSERDATA NU LEFT JOIN CURRENTUSERS"}

 

]

 

IAM_99_0-1670366883809.png

 

2 REPLIES 2

rushikeshvartak
All-Star
All-Star

Use case when end condition of sql


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

IAM_99
Regular Contributor II
Regular Contributor II

okay,  we have SQLs already , thought of checking any other way.