BookmarkSubscribeRSS Feed
Choose Language Hide Translation Bar
Highlighted
DNAFoundry
Community Trekker

Pull SQLite data into JMP

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

0 Kudos
1 ACCEPTED SOLUTION

Accepted Solutions
txnelson
Super User

Re: Pull SQLite data into JMP

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 2
txnelson
Super User

Re: Pull SQLite data into JMP

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
Community Trekker

Re: Pull SQLite data into JMP

 

Great this works, thanks! 

 

 

 

0 Kudos