https://community.jmp.com/t5/Discussions/SQL-code-for-quot-Stack-quot-and-quot-Split-quot-JMP-buttons/m-p/444257#M69215 <P>I've done stuff with <A href="https://docs.microsoft.com/en-us/sql/t-sql/queries/from-using-pivot-and-unpivot?view=sql-server-ver15" target="_self">PIVOT/UNPIVOT</A> in sql server. But it's always custom.&nbsp;&nbsp;</P> Fri, 10 Dec 2021 21:18:38 GMT vince_faller 2021-12-10T21:18:38Z https://community.jmp.com/t5/Discussions/SQL-code-for-quot-Stack-quot-and-quot-Split-quot-JMP-buttons/m-p/443813#M69183 <P>Hi,</P><P>&nbsp;</P><P>Does anyone have a SQL code equivalent for the "split" and "stack" options under JMP Tables menu?&nbsp; Those are very slick and was wondering if there was someone that might know how to do those in SQL?</P><P>&nbsp;</P><P>&nbsp;</P> Sat, 10 Jun 2023 20:48:04 GMT https://community.jmp.com/t5/Discussions/SQL-code-for-quot-Stack-quot-and-quot-Split-quot-JMP-buttons/m-p/443813#M69183 bjbreitling 2023-06-10T20:48:04Z https://community.jmp.com/t5/Discussions/SQL-code-for-quot-Stack-quot-and-quot-Split-quot-JMP-buttons/m-p/444257#M69215 <P>I've done stuff with <A href="https://docs.microsoft.com/en-us/sql/t-sql/queries/from-using-pivot-and-unpivot?view=sql-server-ver15" target="_self">PIVOT/UNPIVOT</A> in sql server. But it's always custom.&nbsp;&nbsp;</P> Fri, 10 Dec 2021 21:18:38 GMT https://community.jmp.com/t5/Discussions/SQL-code-for-quot-Stack-quot-and-quot-Split-quot-JMP-buttons/m-p/444257#M69215 vince_faller 2021-12-10T21:18:38Z https://community.jmp.com/t5/Discussions/SQL-code-for-quot-Stack-quot-and-quot-Split-quot-JMP-buttons/m-p/444695#M69266 <P>It's been a while but I remember this now. Thank you!</P> Mon, 13 Dec 2021 20:35:40 GMT https://community.jmp.com/t5/Discussions/SQL-code-for-quot-Stack-quot-and-quot-Split-quot-JMP-buttons/m-p/444695#M69266 bjbreitling 2021-12-13T20:35:40Z