nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Opening multiple files from a sql server, splitting data and running control charts.

NewUser78

Hi,

Since my last post I've had the method in which to access files changed to a server, I'm trying to connect to the server, pull off several different charts and display them in tables. I then have to manually split the data according to the parameters and readings and then run a control chart builder on them. What I'm looking for is a scirpt that will allow me to automatically pull off the files I need (the server contains a lot of databases of which only about 100 are useful to me). All I have done at the moment is the following (as I said I am very new to jsl and my previous scripting is very limited).

New SQL Query(
Connection(
"ODBC:DRIVER=SQL Server;SERVER=<removed>;UID=<removed>;PWD=<removed>;APP=Microsoft® Windows® Operating System;WSID=<removed>;"

),
QueryName(),
Select( Column( "Parameter", "t1" ), Column( "Reading1", "t1" ) ),
From( Table( "xxx_xxxx", Schema( "dbo" ), Alias( "t1" ) ) );
)<<Run

Would be good to be able to take all the files I need from the database, create tables for each one and then using script split into Parameter and reading and finally create a control chart for each one....not too much to ask. haha.