Transform script not working properly.

ashish9 · ‎05-02-2022

I have a field from which I am trying to push a value to target table but it is not working see screenshot.

Aman Kumar S · ‎05-02-2022

Did you try writing this script in directly in field map? or do you have one already?

If not, can you create one

Can you check in syslog table, if you are getting any error as part of it, also put gs.info to check what is the final value that you are getting, for a string value, I dont think there should be that much of issue

Best Regards
Aman Kumar

View solution in original post

ashish9 · ‎05-02-2022

Ok trying from Direct script as well

Kartik Sethi · ‎05-02-2022

Hi @ashish

Ensure you have update methods called in the Transform Script.

target.update();

Remark: Avoid using target.update() in all Transform Scripts instead add target.update() in the last onAfter Transform Script. Order decides which Transform Script is first or last.

Otherwise have 1 onComplete Transform Script which has the last statement as target.update().

Please mark my answer as correct if this solves your issues!

If it helped you in any way then please mark helpful!

Thanks and regards,

Kartik