Choose Language Hide Translation Bar
Highlighted
NewUser78
Level I

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

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. 

 

Thanks in anticipation. 

Article Labels

    There are no labels assigned to this post.