Class is not importing via Transform map

[Samiksha2]

Hi all,

I have created a transform map in my PDI and trying to add class in that for cmdb_ci table.

Every data is importing except class.

I checked some community link, mentioned to create transform script.

Please help me in creating transform script. 

Thanks,

Sam

[Tony Chatfield2]

Hi, when transforming data the class of the inserted record will always be that of the transform maps target table.
To insert a record into another table, I would normally use a before transform script to lookup and insert the record, before aborting the current transform. Note: you may be able to use a robust transform to deliver this requirement, but I have not tried this as a solution. 

[Samiksha2]

Hi @Tony Chatfield2 ,

Please help me with the script.

Thanks,

Sam

[Samiksha2]

Hi @Tony Chatfield2 ,

Like this I have to create script?

https://www.servicenow.com/community/now-platform-forum/onbefore-transform-script/m-p/1268240?lightb...

[Samiksha2 · Accepted solution]

Its working @Tony Chatfield2 ,

I just write the below script onBefore 

target.sys_class_name = source.u_class;

In the bulk CI upload template we have to define the table name(like cmdb_ci_server), then it will add as Class Server.

Thanks,

Sam