# JuliaDB: convert a Int (0,1) column to Boolean

**URL:** <https://discourse.julialang.org/t/juliadb-convert-a-int-0-1-column-to-boolean/25124>\
**Category:** General Usage\
**Tags:** juliadb\
**Created:** [June 10, 2019, 6:19pm UTC](https://discourse.julialang.org/t/juliadb-convert-a-int-0-1-column-to-boolean/25124 "2019-06-10T18:19:58Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![GdMacmillan](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/gdmacmillan/32/8839_2.png) [@GdMacmillan](https://discourse.julialang.org/u/GdMacmillan)\
**Post date:** [June 10, 2019, 6:19pm UTC](https://discourse.julialang.org/t/juliadb-convert-a-int-0-1-column-to-boolean/25124/1 "2019-06-10T18:19:58Z")

</div>

Hi, pretty straightforward question here:

How would I go about converting a JuliaDB table column of type Int64 to Boolean values so I can run counts…

I was thinking something like `select(t, :is_bad => convert)` but convert takes a positional argument which is the type to convert to and I’m not sure how to specify this

---

<div class="post-metadata">

**Author:** ![mbauman](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/mbauman/32/31082_2.png) [@mbauman](https://discourse.julialang.org/u/mbauman)\
**Post date:** [June 10, 2019, 6:48pm UTC](https://discourse.julialang.org/t/juliadb-convert-a-int-0-1-column-to-boolean/25124/2 "2019-06-10T18:48:31Z")

</div>

In this particular case you can use `select(t, :is_bad => Bool)`. More generally, you can use anonymous functions for arbitrary transforms like `select(t, :is_bad => x->convert(Bool, x))`.

---

<div class="post-metadata">

**Author:** ![GdMacmillan](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/gdmacmillan/32/8839_2.png) [@GdMacmillan](https://discourse.julialang.org/u/GdMacmillan)\
**Post date:** [June 10, 2019, 11:33pm UTC](https://discourse.julialang.org/t/juliadb-convert-a-int-0-1-column-to-boolean/25124/3 "2019-06-10T23:33:38Z")

</div>

Thanks. That’s perfect