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