topic Re: Table Data in Discussions

Table Data

mallen810 — Thu, 12 Jan 2017 15:37:02 GMT

I have been searching the boards to see how to bring in all rows of a data set through a query. But when I run the query it only returns the first three rows of data. I know it is probably a simpe solution to this but havent been able to find. Any help with this would be greatly appreciated.

mallen810

Re: Table Data

uday_guntupalli — Thu, 12 Jan 2017 16:17:07 GMT

@mallen810,
What is the form of this data set ? Can you paste a sample of the data and the query ?

Best

Uday

Re: Table Data

ms — Thu, 12 Jan 2017 16:41:09 GMT

This may not apply to your setup, but if using JMP for Macintosh and the trial version of Actual Tecnologies ODBC-drivers, any query would only return the first three rows of data. Only after licencing the driver one can get all rows.

Re: Table Data

mallen810 — Thu, 12 Jan 2017 17:21:08 GMT

Thanks, I do think I have the trial version on my Mac. Will update to the full version and try again.

Re: Table Data

mallen810 — Thu, 12 Jan 2017 17:21:09 GMT

Thanks, I do think I have the trial version on my Mac. Will update to the full version and try again.

Re: Table Data

mallen810 — Thu, 12 Jan 2017 17:38:45 GMT

Went and purchased the license and everything is working now. Thanks again.