cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Browse apps to extend the software in the new JMP Marketplace
Choose Language Hide Translation Bar
hogi
Level XII

Database access

Hi,

 

when I generate a Database Query via the GUI in Jmp, how can I use advanced SQL functionality?

  • SQL formulas (rand (),txt = Substring(), myValue = a+b )
  • Explode
  • Lateral View 
1 ACCEPTED SOLUTION

Accepted Solutions
jthi
Super User

Re: Database access

Most likely JMP's SQL GUI doesn't support all possible SQL commands and functions which are available depending on which SQL is being used but you could convert the query to Custom SQL and add those yourself

jthi_0-1695825935877.png

or something is maybe found from computed columns

jthi_2-1695826021482.png

jthi_1-1695825999719.png

 

-Jarmo

View solution in original post

4 REPLIES 4
jthi
Super User

Re: Database access

Most likely JMP's SQL GUI doesn't support all possible SQL commands and functions which are available depending on which SQL is being used but you could convert the query to Custom SQL and add those yourself

jthi_0-1695825935877.png

or something is maybe found from computed columns

jthi_2-1695826021482.png

jthi_1-1695825999719.png

 

-Jarmo
hogi
Level XII

Re: Database access

red triangle -> hidden wonderland.

 

concerning 

  • Explode
  • Lateral View

... maybe a developer will find this post and consider implementing it in a future release ...

 

hogi
Level XII

Re: Database access

easier to find: wish list
advanced SQL options 

Re: Database access

Thanks for the solution.