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:
My SQL database has the columns like this:
I would like a query to bring in the data to jmp like this:
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?
Go to 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
Specify data_type as the Split By value
Specify Result as the Split Columns
Great this works, thanks!