By default, loading data from Excel only handles strings.
To handle date, number, etc. in a mapping with an Excel spreadsheet as source, the following functions can be used to convert data type on load:
- to_number()
- to_date()
- to_timestamp()
- to_time()
- to_boolean()
For example :
Make sure the execution location is on "Source".