Hi Andrew, You can use the select values transform and in there use the metadata tab to change the datatype of a field. This can be used to change dates to strings or int/strings to boolean and so on [1].
Hope this helps, Kr, Hans [1] https://hop.apache.org//manual/latest/pipeline/transforms/selectvalues.html#_meta_data_tab On 22 May 2023 at 21:20 +0200, Galewsky, Andrew <[email protected]>, wrote: > As far as I know there is nothing specific about that in the connection for > postgresql.... > > -Andrew > > > On Mon, May 22, 2023 at 1:39 PM Matt Casters > > <[email protected]> wrote: > > > Did you enable boolean support in the relational database connection? > > > > > > > > > > > > > Op ma 22 mei 2023 20:04 schreef Galewsky, Andrew <[email protected]>: > > > > > I have been fighting this since I started using hop. For example I > > > > > have a database field that is boolean but the incoming field has some > > > > > dirty data and is not able to be set as a bool in its temp table. It > > > > > has to be a varchar. As part of the pipeline the data gets cleaned > > > > > up and is now truly boolean. As far as I can tell now there is no > > > > > way to cast it as bool before writing to the output table. Am I > > > > > dense or missing something?. > > > > > > > > > > -Andrew Galewsky
