[abstrphil]

q interprets right-to-left, so what your first expression is actually doing is executing the lj on jan09 before selecting from it.

What it’s therefore doing is counting the number of rows from the combined table.

The second expression is selecting the table *then* executing the join, which is why you now see the avgTemps.

[abstrphil]

On a separate note, in the Joins Exercises, the suggested solution for the third-last exercise throws up a type error as the `time` column is a minute type.

• This reply was modified 1 month, 2 weeks ago by  abstrphil.

[abstrphil]

Probably doesn’t help with your problem, but you can un-nest the multiple ifs:

https://code.kx.com/q/ref/cond/#odd-number-of-expressions

code.kx.com

Cond | Reference | kdb+ and q documentation - kdb+ and q documentation

Cond is a q control construct for conditional evaluation.

[abstrphil]

Piggybacking off this topic, I made a similar error and got a similar result, however in my case, fixing the function didn’t work.

I can verify that running fiaHandle”tables[]” returns `notAuthorized, but the test is still failing.

[abstrphil]

Yes, sure, by all means!

Feel free to leave critique of my code too if you spot anything!

[abstrphil]

Hi Megan,

Unfortunately, that didn’t fix it. The output was still the same.

• This reply was modified 1 month, 2 weeks ago by  abstrphil.

[abstrphil]

Thanks for the help, it did work. However, I’d just like to point out one minor issue (but perhaps it’s been fixed since): if I have to restart the kernel for whatever reason, I think there are some hidden cells (presumably containing the import and  `qfirst_enable`,  which don’t run unless you explicitly run all cells above a selected cell.