https://community.jmp.com/t5/Discussions/Database-access/m-p/686971#M87256 <P>Thanks for the solution.</P> Fri, 13 Oct 2023 13:58:08 GMT ElizabethVarner 2023-10-13T13:58:08Z https://community.jmp.com/t5/Discussions/Database-access/m-p/681508#M86709 <P>Hi,</P><P>&nbsp;</P><P>when I generate a Database Query via the GUI in Jmp, how can I use advanced SQL functionality?</P><UL><LI>SQL formulas (rand (),txt = Substring(), myValue = a+b )</LI><LI>Explode</LI><LI>Lateral View&nbsp;</LI></UL> Wed, 27 Sep 2023 06:45:03 GMT https://community.jmp.com/t5/Discussions/Database-access/m-p/681508#M86709 hogi 2023-09-27T06:45:03Z https://community.jmp.com/t5/Discussions/Database-access/m-p/681696#M86728 <P>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</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="jthi_0-1695825935877.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/57026i25473918F78300A5/image-size/medium?v=v2&amp;px=400" role="button" title="jthi_0-1695825935877.png" alt="jthi_0-1695825935877.png" /></span></P> <P>or something is maybe found from computed columns</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="jthi_2-1695826021482.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/57028iF960E43D19151DEE/image-size/medium?v=v2&amp;px=400" role="button" title="jthi_2-1695826021482.png" alt="jthi_2-1695826021482.png" /></span></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="jthi_1-1695825999719.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/57027iA4C57D29BA8F6FA1/image-size/medium?v=v2&amp;px=400" role="button" title="jthi_1-1695825999719.png" alt="jthi_1-1695825999719.png" /></span></P> <P>&nbsp;</P> Wed, 27 Sep 2023 14:49:45 GMT https://community.jmp.com/t5/Discussions/Database-access/m-p/681696#M86728 jthi 2023-09-27T14:49:45Z https://community.jmp.com/t5/Discussions/Database-access/m-p/681789#M86743 <P>red triangle -&gt; hidden wonderland.</P><P>&nbsp;</P><P>concerning&nbsp;</P><UL><LI>Explode</LI><LI>Lateral View</LI></UL><P>... maybe a developer will find this post and consider implementing it in a future release ...</P><P>&nbsp;</P> Wed, 27 Sep 2023 21:01:46 GMT https://community.jmp.com/t5/Discussions/Database-access/m-p/681789#M86743 hogi 2023-09-27T21:01:46Z https://community.jmp.com/t5/Discussions/Database-access/m-p/684557#M87034 <P>easier to find: wish list ;)</img><BR /><LI-MESSAGE title="advanced SQL options" uid="684551" url="https://community.jmp.com/t5/JMP-Wish-List/advanced-SQL-options/m-p/684551#U684551" discussion_style_icon_css="lia-mention-container-editor-message lia-img-icon-idea-thread lia-fa-icon lia-fa-idea lia-fa-thread lia-fa"></LI-MESSAGE>&nbsp;</P> Fri, 06 Oct 2023 14:51:55 GMT https://community.jmp.com/t5/Discussions/Database-access/m-p/684557#M87034 hogi 2023-10-06T14:51:55Z https://community.jmp.com/t5/Discussions/Database-access/m-p/686971#M87256 <P>Thanks for the solution.</P> Fri, 13 Oct 2023 13:58:08 GMT https://community.jmp.com/t5/Discussions/Database-access/m-p/686971#M87256 ElizabethVarner 2023-10-13T13:58:08Z