Transform script not working properly.

ashish9
Tera Contributor

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

1 ACCEPTED SOLUTION

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

11 REPLIES 11

Hi Allen,

 

It resolved the issue Just testing with another approach from another reply. I have tried your approach it is working fine and it is updating all the record for now as there is no condition, I will add condition, check 2nd approach and will mark correct and helpful whichever suits. Thank You so much Allen.

Hi,

Regardless of a condition being added, it doesn't affect the fact that you have to use GlideRecord to update the record in an onAfter script, which is what I mentioned above.

In either case, it's your thread, so whatever works for you, but for the sake of future readers, what I've posted above is what answered your question as to why your script didn't work, again, regardless of any additional script you're trying to add. That is something on your end and doesn't change what will work for updating the record or not.

Thanks and take care! 🙂

 


Please consider marking my reply as Helpful and/or Accept Solution, if applicable. Thanks!

Aman Kumar S
Kilo Patron

Hey,

I think you should write onBefore, instead of onStart, if you are trying to update a particular field in the target table

Best Regards
Aman Kumar

Hi Aman, I have tried all 3 type of script before after and complete 

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