# How to check the problem of one date data in partition table? **URL:** \ **Category:** Community Support\ **Tags:** kdb-and-q\ **Created:** [December 13, 2017, 3:39am UTC](https://forum.kx.com/t/how-to-check-the-problem-of-one-date-data-in-partition-table/11655 "2017-12-13T03:39:00Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![carfield11](https://avatars.discourse-cdn.com/v4/letter/c/ec9cab/32.png) [@carfield11](https://forum.kx.com/u/carfield11)\ **Post date:** [December 13, 2017, 3:39am UTC](https://forum.kx.com/t/how-to-check-the-problem-of-one-date-data-in-partition-table/11655/1 "2017-12-13T03:39:00Z")
HI, if I run this query: select from `:/folder/trade/ (trade suppose to be a partition table with trade data ) And it get “length” error, anything I can do to further check what is the problem? Say which column have less element than other column? ---
**Author:** ![charlie1](https://avatars.discourse-cdn.com/v4/letter/c/ec9cab/32.png) [@charlie1](https://forum.kx.com/u/charlie1)\ **Post date:** [December 13, 2017, 8:20am UTC](https://forum.kx.com/t/how-to-check-the-problem-of-one-date-data-in-partition-table/11655/2 "2017-12-13T08:20:00Z")
q)`:db/2000.01.01/t/ set (a:til 10;b:til 10;c:til 10) q)`:db/2000.01.01/t/c set til 5 q)select from `:db/2000.01.01/t 'length   [0]  select from `:db/2000.01.01/t               ^ q)count each `:db/2000.01.01/t/ each get `:db/2000.01.01/t/.d 10 10 5 ---
**Author:** ![carfield11](https://avatars.discourse-cdn.com/v4/letter/c/ec9cab/32.png) [@carfield11](https://forum.kx.com/u/carfield11)\ **Post date:** [December 15, 2017, 10:47am UTC](https://forum.kx.com/t/how-to-check-the-problem-of-one-date-data-in-partition-table/11655/3 "2017-12-15T10:47:00Z")
Thanks a lot Charles, it is very helpful