Hi @rosspyres , can you assume that any boolean columns should actually be Integers, and that true should be 1, whilst false should be 0?
If that’s the case, you may be able to make use of my Rule Engine (multi column) component.
Give it the following script, and untick the “Append column” option. Not ideal, but it may at least be sufficiently generic. It may be a little slow on large datasets though.
"<CURRENTCOLUMNTYPE>" LIKE "Boolean*" AND $CURRENTCOLUMN$ = "true" => 1
"<CURRENTCOLUMNTYPE>" LIKE "Boolean*" AND $CURRENTCOLUMN$ = "false" => 0
TRUE => $CURRENTCOLUMN$
