Forum Discussion

jerrywalk1's avatar
jerrywalk1
Regular Visitor
7 years ago

we cannot convert the value null to type logical...

I am getting the error "we cannot convert the value null to type logical..". The problem is that it tells me what table when trying to load but it does not tell me what column nor does it create an e...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
7 years ago

In the Query Editor, logical columns should show up as having a red X and green checkmark in their column header. Perhaps you can track it down that way. The other way would be to filter out nulls on each column until you find the right one.

  • jerrywalk1's avatar
    jerrywalk1
    Regular Visitor
    7 years ago

    So, i looked at the columns and there were no red x or green checkmarks. I went thru each column and had it remove null values. Nothing changed. I keep getting Value =  and Type = Type with the error we cannot convert value to type logic. This is frustrating as I know its in the current table but nothing tells me where.

  • jerrywalk1's avatar
    jerrywalk1
    Regular Visitor
    7 years ago

    sorry i have been out on vacation. I will try the solution today.

    Greg_Deckler wrote:

    In the Query Editor, logical columns should show up as having a red X and green checkmark in their column header. Perhaps you can track it down that way. The other way would be to filter out nulls on each column until you find the right one.