Would someone be able to provide syntax of using lookup transform as part of “Account Create Profile”?
Scenario:
Below transform stores the mapping between source system and timezone. Keys correspond to the source name.
{
"attributes": {
"table": {
"sde-global": "America/Los_Angeles",
"sde-brz": "America/Sao_Paulo",
"sde-sea": "Pacific/Auckland"
}
},
"type": "lookup",
"name": "sde_timezone_sid_key"
}
As part of source “sde-global”, there is a field named “TimeZoneSidKey” that we would like to populate from the above lookup transform.
{
"name": "TimeZoneSidKey",
"transform": {
""What is the syntax to lookup the value from the above table. We need to lookup value based on the source name and assume in this case “sde-global""
}
},
"attributes": {},
"isRequired": false,
"type": "string",
"isMultiValued": false
}