Transform map is changing the field value to upper case
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-29-2024 05:43 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-29-2024 05:46 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-29-2024 05:59 AM
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,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-29-2024 06:02 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-29-2024 06:10 AM
Hi ,
Please check the below transform field mappings and script -