doobdargent
doobdargent

Reputation: 722

Fusion tables query does not fetch some

I'm having an issue on this table: 1g_ydg74ooUSBzNfQBHOIdgrOKhxZD_92In8xTDg

I'm trying to fetch some results by CODE_DEPT. I used the filter

CODE_DEPT IN ('001', '002', '003', '02A', '02B')

and only the 3 first are fetched.

Any idea what's going on ? Cheers

Upvotes: 1

Views: 64

Answers (1)

Rod McChesney
Rod McChesney

Reputation: 261

Looks like CODE_DEPT is identified as a numeric column. The last two codes are not numeric and so would not match anything. If you change the column to type Text and you should be OK.

Upvotes: 1

Related Questions