OnStart transform script update
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-18-2022 05:41 PM
Hello,
Can we do update using onStart transform script? I was trying to make the value of the field "true" before the transform runs. But it doesn't seem to be working. Can we not do update in onStart transform script?
Appreciate all the help.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-18-2022 05:46 PM
Hello,
onStart scripts are before any individual rows have been read.
Your post isn't very clear if you're trying to update the value of a field on the staging table or the target table, but in either case, it's before any actual rows are read and is essentially at the table level.
If trying to use "source", it's only for the very first row, no other rows.
It sounds like you may want to utilize an onBefore script.
Please mark reply as Helpful/Correct, if applicable. Thanks!
Please consider marking my reply as Helpful and/or Accept Solution, if applicable. Thanks!