Do people code golf using SQL?

My life would be complete. ;-)

@TorstenGrust there's even a tips page

@ngn cliick

@ngn Thanks Adam, but I'll leave it the golfers. I avoid real golf and code golf!

@PaulMansour I guess I won't be seeing you at the code golf workshop at Dyalog '19.

CMP: Should the APLcart input field be monospace instead of the current proportional font?

@ngn Are not fill and coalesce

two different functions?

In SQL coalesce is a type of aggregate functions that works across multiple columns, rather than down a single function.

down a single "column"

@Adám No, but I did sign up for Trains and High Ranking Operations!

@PaulMansour "The COALESCE function returns the first argument that is not null." -W. if i understand correctly, k's ^ used to do the same, except vectorized. unfortunately i don't have access to a k version to test with (<k3 ?)

@Adám yes. and it shouldn't ignore occasional keystrokes in ff on linux :)

@Adám definitely

@ngn You are correct. Upon a little coffee and reflection, fill and coalesce are closely related. Q has fill and fills (and coalesce for tables). It looks like with fill properly defined, everything else one would want to do is handed by reduction and scan.

@ngn Of course it shouldn't, but IANAJSP. Please PR. (Btw, Marshall has an issue where the input field loses focus after every keystroke!)

tfw you revisit the Dyalog competition and it turns out your Phase I solution can become way more APLy

@Adám @Adám Adam, I am trying to read an excel file. It is something I do on a regular basis but on occasion I get a value error when using the same DDE statements I always use. The spreadsheet is open and the worksheet is named correctly and has data but I get value error.

@preaburn I think I've heard of such before. Can you email support@dyalog.com about it? I'll also ask someone to dome into the room to help you out.

@preaburn If you put your code in a separate message and press Ctrl+K, it will print nicer.

@Adám Sorry for the last message. I sent an email with a picture of the code and the error message.

@Adám, just a follow up on the excel issue. It turns out I can write to the excel sheet by assigning numbers to the shared variable but when I try to read the shared variable it gives me a value error.

@preaburn You're looking at excel.dws, right?

@Adám I am not sure what you mean by dws?

@preaburn Dyalog WorkSpace. excel.dws is one of the sample workspaces bundled with Dyalog. You may want to have a look at loaddata.dws. Just type )load loaddata

@Adám OK. I have never used the sample workspaces. I will look at it.

Now that I think of it, obviously scan is not what I want here

Can I do that with ⍣ though?

(I forgot it's almost Shabat, so no need to worry about answering)

@J.Sallé somebody said "scan" :)

⎕←{∪⍵,⊂2↓⊃⌽⍵}⍣≡⊂⍳10

@ngn
┌────────────────────┬────────────────┬────────────┬────────┬────┬┐
│1 2 3 4 5 6 7 8 9 10│3 4 5 6 7 8 9 10│5 6 7 8 9 10│7 8 9 10│9 10││
└────────────────────┴────────────────┴────────────┴────────┴────┴┘

they call me @n "scan" gn

shorter:

⎕←∪{2↓⍵}\⊢¨∘⊂⍨⍳10

@ngn
┌────────────────────┬────────────────┬────────────┬────────┬────┬┐
│1 2 3 4 5 6 7 8 9 10│3 4 5 6 7 8 9 10│5 6 7 8 9 10│7 8 9 10│9 10││
└────────────────────┴────────────────┴────────────┴────────┴────┴┘

in k: (2_)\!10

@Adám i don't have time for a pr, but modern dom should be simpler and likely faster than datatables.js. i think you should throw away the dependency and do searchField.onkeyup=_=> go through all results and resultElement.hidden= 0 or 1 depending on whether they match