Forum Discussion
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...
Greg_Deckler
Community Champion
Community ChampionIn 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.
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.