I am trying to create a Selection View in order to convert text value columns in a delimited file based data source to other data types, based on :
Initially, I was attempting to convert data strings, using to_timestampz() function, but this always results in a <null> value.
I then tried to convert simple numeric strings to decimal/int/float types, but again, this always results in <null>
Now, I appreciated that this is specifically for Excel files – but was assuming this would also work for delimited file sources.
However, having revisited the documentation for Delimited File Sources, I do not see any such information on conversion. Does this mean, it is simply not possible to convert text values in a delimited file source?