topic Re: Pull SQLite data into JMP in Discussions

Pull SQLite data into JMP

DNAFoundry — Thu, 04 May 2017 15:01:13 GMT

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:

key	Variable1	variable2	variable3
1	-	-	-
2	-	-	-

My SQL database has the columns like this:

key	data_type	result
1	Variable1	12.6
1	Variable2	15.4
1	Variable3	17.8
2	Variable1	8.2
2	Variable2	7.1
2	Variable3	7.2

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

jmptable:

key	Variable1	variable2	variable3
1	12.6	15.4	17.8
2	8.2	7.1	7.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

Re: Pull SQLite data into JMP

txnelson — Thu, 04 May 2017 15:40:09 GMT

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

Re: Pull SQLite data into JMP

DNAFoundry — Thu, 04 May 2017 15:58:55 GMT

Great this works, thanks!