KX Community

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

Home Forums kdb+ select with ssr function

Tagged: ,

  • select with ssr function

    Posted by mkoon on June 17, 2024 at 1:15 am

    need some help with a query.

    I am trying to select a column and apply a function. This function would ssr an existing column.

    select {[x](ssr[x;".C";""])} orderID, cancelTime from t

    Sample Table

    orderID                cancelTime                   
    ----------------------------------------------------
    "00193932455ORSL1.4.C" 2023.06.13D14:42:12.296856000
    "00193935456ORSL1.1.C" 2023.06.13D13:56:47.006888000
    "00193946420ORSL1.1.C" 2023.06.13D14:41:40.911418000
    "00194008439ORSL1.5.C" 2023.06.13D17:14:06.267606000
    • This discussion was modified 1 month ago by  mkoon. Reason: clarity
    • This discussion was modified 1 month ago by  mkoon.
    mkoon replied 1 month ago 2 Members · 2 Replies
  • 2 Replies

Log in to reply.