How to query a large data table based on a column level and return columns whose name contains that level?
We want to build a quality monitoring application to deploy across dozens of production facilities (eventually publish to JMP Live). For each facility, we have a very tall & wide data table (let's call it dtBigBoy, <1000 cols, 10k-100k rows) that is refreshed from a process data historian which cannot be queried directly (we get all the data between start/stop timestamps and concatenate the fres...