KX Community

Find answers, ask questions, and connect with our KX Community around the world.
KX Community Guidelines

Home Forums kdb+ How to remove an empty symbol from q dictionary Re: How to remove an empty symbol from q dictionary

  • davidcrossey

    Member
    July 3, 2023 at 12:00 am

    If you mean remove the null key, you can drop the null using the following syntax:

    q)show d:(4?(0Nd,3?.z.D))!1 2 3 4 2006.11.03| 1 2008.12.03| 2 | 3 | 4 q)enlist[0Nd] _ d 2006.11.03| 1 2008.12.03| 2