is the kdb documentation on upsert on a splayed table wrong or

Community Support
1

I am trying to use upsert on a splayed table. If you run the example documented in http://code.kx.com/wiki/JB:KdbplusForMortals/splayed\_tables section 1.2.4.1 you get a type error. Is upsert actually supported on a splayed and partitioned table ? (v 3.3 32 and 64 bit versions)  if supported does anybody have sample code that works ?

2

sorry, that example is no longer valid.
Can use

.[`:/db/t/;();,;flip`ti`p!(10:00:01 19:00:02;43.0 40.0)]

3

hey thanks Charles ! is any of that documented elsewhere ? 

4

Probably not explicitly, so apologies, we’ll fix that.

It’s slightly more readable as

:/db/t/ upsert flipti`p!(10:00:01 19:00:02;43.0 40.0)

There’s an example hidden in here, but you’d have to look closely

http://code.kx.com/wiki/Cookbook/LoadingFromLargeFilesAndSplaying

.Q.fs[{ .[`:dir/trade/; (); ,; .Q.en[`:dir] flip colnames!("DFFFFIS";",")0:x]}]`:file.csv