KX Community

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

Home Forums kdb+ Challenge 4 – World Cup Re: Challenge 4 – World Cup

  • Laura

    Administrator
    July 3, 2023 at 12:00 am

    You can do it through qsql syntax:

     exec (string[player],'" from ",/:string[country],'" scored a goal in the ",/:string[minute],:"th minute") from data

    Useful information for this can be found here:
    https://subhabratachoudhury.com/p/2016/05/concatenating-kdb-columns/
    If you want to display to console each of these you can put a 0N! each in front of the above exec state.