Append comments using transform script

[KeithM2]

I'm working on a transform script but I'm not sure how to do it.  I'm updating the assets (alm_hardware table) when we dispose/retire the equipment.  I'm coalescing on the asset tag# and it seems to be working.  What I need help with is when it finds the record, it appends the order # to the comments.  Not every record has something in the comments field, but if it does i don't want to lose it.   Any suggestions?

[joel_ruiz1]

In place of the transform mapping, check the "Run script" box on the transform map. (see screenshot)

It would look something like that. If you provided screenshots and the field names I could help you out more.

Hope this helps!

-Joel R.