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…