Skip to content

Instantly share code, notes, and snippets.

@a2ndrade

a2ndrade/db.q

Last active August 5, 2016 15:44
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save a2ndrade/08bb7417b901e904d3b4 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save a2ndrade/08bb7417b901e904d3b4 to your computer and use it in GitHub Desktop.
Download ZIP
Atomic
Raw
atomic.q
/ data sample
V:"abcdefghijklmnopqrstuvwxyz" / universe of values
e:1 1 2 3 4 4 4 4 4 4 4 5 6 6 6 6 6 6 8 8 / entity column
v:V@(#e)_draw#V / value column
/ sorting table
whereLatestE:-1+*:'1_=e,#e
uniqueE:e[whereLatestE]
latestV:v[whereLatestE]
sortedTable:.+(`e`v;(uniqueE;latestV))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment