how to merge DATS that are within group of dynamic BASEs

Hello forum,

I have a table DAT and a few BASEs, each BASE has a table inside with one row of values:

I would like a top level DAT that always has the merged result of all rows from the existing BASEs, even if the number of BASEs change. i.e. if using a wildcard in a select DAT worked like this:

What’s the best way to do this? I’m not sure what’s chicken and what’s egg when trying to script it…

The Merge DAT does wildcards like this fortunately.

Oh man, so much easier! Thanks!