681508_en-US

liliconcom

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 

Data AccessRe: 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

or something is maybe found from computed columns

 

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 ...

 

Re: Database access

easier to find: wish list
advanced SQL options 

Re: Database access

Thanks for the solution.