Transform map is changing the field value to upper case

Neeta1
Tera Contributor

Hi Experts ,

We have a created one transform map on cmdb_ci class , where name and serial number are set as "Colease" to update the record. However it is changing the Name and Serial number from lower case to upper case, which is coming from the source data. Is there any way to stop changing to upper case ?

Thank you in advance.

6 REPLIES 6

AshishKM
Kilo Patron
Kilo Patron

Hi @Neeta1

Can you check the incoming value in stage table and print the same in log before setting it to target table.

Also please share the mapping details, any script written for it or just column to column mapping. You can also try to use toLowerCase() method.

 

-Thanks,

AshishKM


Please mark this response as correct and helpful if it helps you can mark more that one reply as accepted solution

Neeta1
Tera Contributor

Hi ,

Thank you for your response. 

Basically we don't want to update the Name or Serial number either to Lower or upper case whatever is coming up from the source. Could you please suggest how to stop changing it ?

 

Thank you,

This is specific, subject to transform map configuration. 

Is this happening for all CIs or just for some.

Please share the transform mapping and any script written.


Please mark this response as correct and helpful if it helps you can mark more that one reply as accepted solution

Neeta1
Tera Contributor

Hi ,

Please check the below transform field mappings and script - 

Neeta1_0-1711717692991.pngNeeta1_1-1711717802287.png