cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
DNAFoundry
Level I

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

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

View solution in original post

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
Level I

Re: Pull SQLite data into JMP

 

Great this works, thanks!