Subscribe Bookmark RSS Feed

Pull SQLite data into JMP

DNAFoundry

Occasional Contributor

Joined:

Mar 17, 2017

Hi,

 

I have my data stored in an sqlite database and would like to pull it into JMP and merge with my DOE design.

 

My jmp file looks like this:

keyVariable1variable2variable3
1---
2---

 

 

My SQL database has the columns like this:

keydata_typeresult
1Variable112.6
1Variable215.4
1Variable317.8
2Variable18.2
2Variable27.1
2Variable37.2
   

 

I would like a query to bring in the data to jmp like this:

jmptable:

keyVariable1variable2variable3
112.615.417.8
28.27.17.2

 

I have set up the SQL connection and that is working fine. So what I would like to do is join the tables and transpose the data into the correct variable columns. Any idea how to do this?

 

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
txnelson

Super User

Joined:

Jun 22, 2012

Solution

All you need to do, is after you have initially read in your table from your SQlite database is to then Split the data into a new table

     Tables==>Split

Specify data_type as the Split By value

Specify Result as the Split Columns

split0.PNG

split1.PNG

split2.PNG

 

 

Jim
2 REPLIES
txnelson

Super User

Joined:

Jun 22, 2012

Solution

All you need to do, is after you have initially read in your table from your SQlite database is to then Split the data into a new table

     Tables==>Split

Specify data_type as the Split By value

Specify Result as the Split Columns

split0.PNG

split1.PNG

split2.PNG

 

 

Jim
DNAFoundry

Occasional Contributor

Joined:

Mar 17, 2017

 

Great this works, thanks!