Database access

[#1]

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 

[#2 · Accepted solution]

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

or something is maybe found from computed columns

[#3]

red triangle -> hidden wonderland.

concerning 

• Explode
• Lateral View

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

[#4]

easier to find: wish list
advanced SQL options 

[#5]

Thanks for the solution.