Hello,
Sorry changed my mind on a second read. Basing this on YES
and NO
in columns.
Imported into Base as Varchar. Then with a second table definition set the same except the Yes/No field set as Boolean, used SQL to copy:
Insert Into "Bool4b" SELECT "id", "name", Case When "b0" = 'YES' Then 1 Else 0 END FROM "Bool4"
Result:
Bool4
was original paste and Bool4b
is the SQL inserted data. Tested with HSQLDB embedded & LO v7.0.4.2 on Ubuntu 20.04. Other databases will be similar.
If this answers your question please tick the (upper left area of answer). It helps others to know there was an accepted answer.