Transform mapping - Load data - to load only newly added comments instead of whole thread, duplicate

[maneesh3]

Hi Team,

I am using Load data module to load records into Case table using excel sheet. For, additional comments it is always copying whole thread each and every time, and making data look more. Can it be possible to only copy newly added comments instead of adding always thread . Please help!

Thanks for support

[maneesh3]

Hi @Abhit ,

Please find attached sheet

[Abhit]

You can split the additional comment with the empty line or based on the date and just extrat the first index.
try this with the source field script or transform script.

Sample:
source.u_additional_comment.split("\n")[1];

this will give you the second line from the additional comment.

Thanks
Abhit

[Di Zhang]

Does Excel itself contain historical additional comments? If so, it is necessary to obtain the latest information in Transform map.

[maneesh3]

Hi @Di Zhang ,

yes, this excel contains historical comments,

[Di Zhang]

so you should removed it in transform map before loading to target table.