John Kerl

Also what other verbs besides `mlr cat` (OK) and `mlr sort` (not)? What about `mlr head` or `mlr tail` etc. ?

@indigoviolet weird 😬

> Even weirder: I built from source to see if that was the problem: OK, if we're building from source 😁 ... can you go here https://github.com/johnkerl/miller/blob/main/internal/pkg/transformers/sort.go#L71 and put a...

Thanks @indigoviolet -- TIL about `zsh` aliases!! 😁

First one: currently it's not but I can look into it. I'd need to error out immediately if the command line specifies main input from stdin *and* join input from...

@trantor yes it makes sense ... mostly. One key thing about Miller is that it indexes by unique names so ``` a,b,c 1,2,3 4,5,6 4,8,9 ``` would transpose to ```...

@trantor here is a DSL proof of concept: ``` $ cat example.csv color,shape,flag,k,index,quantity,rate yellow,triangle,true,1,11,43.6498,9.8870 red,square,true,2,15,79.2778,0.0130 red,circle,true,3,16,13.8103,2.9010 red,square,false,4,48,77.5542,7.4670 purple,triangle,false,5,51,81.2290,8.5910 red,square,false,6,64,77.1991,9.5310 purple,triangle,false,7,65,80.1405,5.8240 yellow,circle,true,8,73,63.9785,4.2370 yellow,circle,true,9,87,63.5058,8.3350 purple,square,false,10,91,72.3735,8.2430 $ cat xpose.mlr @inrecs[NR] = $*; @inr...

See also https://github.com/johnkerl/miller/issues/321

Hi @alexhallam ! The way Miller handles non-matches is with the `--ul` and `--ur` flags to join. That said, the semantics of how Miller does joins aren't well-mapped to some...

Thanks @alexhallam & @aborruso. Indeed, `unpaired` is Miller jargon & the docs need to be clearer about how this maps back and forth with more database-standard terminology like `left join`...