Transform map - User defined variable for all rows
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
5 hours ago
HI team
I would like to read a System property from a Transform map and store it in a user defined variable
ex - allowedlistsysprop and have the variable available for all row transformations
Basically i have a list of allowed matches in a system property and would like to do string match something like below for each row
if (source.myfield1.indexOf(allowedlistsysprop) != -1)
{
//do something
}
I would read the property only once and can define the variable in an onStart script .But not sure how to properly define it in onStart script and access it in each of the OnBefore script and more important make sure the variable doesn't leak into any other process .
i am reading some references setting it as a global variable using onStart script . But how do i make sure the variable doesnt spam other processing .Appreciate any guidance around this
Thanks in advance
Lakshmi