• kdb+

  Syntax to extract a particular key-value from BSON message

  Posted by priya on January 22, 2024 at 12:00 am

  Hi,

   

  I’m new to q language. My question is

  what is the syntax to extract a particular key-value from BSON message?

  For instance if I need SourceSystemName from the key value pair in BSON message for all 50k records  how can i extract that?

   

  Thanks,

  Priya

  priya replied 8 months, 2 weeks ago 2 Members · 1 Reply
• 1 Reply

• 

  rocuinneagain

  Member

  January 22, 2024 at 12:00 am

  You can index at depth:

  records[;`SourceSystemName]

  https://kx.com/blog/kdb-q-insights-parsing-json-files/

Log In to Reply