Cast variable in mapper into a specific datatype before insert or update into a database
how to cast a variable in mapper to a specific datatype before inserting or updating it into a table?
Forum Discussion
3 Replies
From what I have happened to see, I know this is possible to do in the mapper.
What are the source and destination types you are looking to convert? Here are some conversions that are available:
- parseFloat()/parseInt() - Convert a string into a number
- Date.parse() - Convert a string to a date
- To convert a value (other than null) to a string, you can call the ‘.toString()’ method on the object.
- JSON.stringify() - Converts a value to JSON.
I want to convert a mapper variable into a varchar2(100) datatype, is that possible on snaplogic?
