KX Community

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

Home Forums kdb+ Iterators with tables

  • Iterators with tables

    Posted by kb on October 12, 2023 at 12:00 am

    Hello All!

    I have a table similar to this:

    sym    |    price                   |    level    |    lowertime | upperTime

    ——-|———————|———-|—————-|—————

    `abc        10.0 20.3 13.5…         15.0         null                  null

    `cde       11.0 21.3 13.5…             16.0         null                  null

     

    I need to check if for each sym, if any price<=level then update upperTime:1.

    Need help with this query.

    kb replied 3 months, 1 week ago 2 Members · 1 Reply
  • 1 Reply
  • cillianreilly

    Member
    October 12, 2023 at 12:00 am

    Assuming the sym column in your original table is distinct:

    q)update upperTime:1 from t where any each price<=level 
    sym price level lowerTime upperTime 
    ------------------------------------------ 
    abc 10 20.3 13.5 15 1 
    cde 11 21.3 13.5 16 1

Log in to reply.