topic Re: save matrix as table variable? in Discussions

save matrix as table variable?

nikles — Fri, 27 Oct 2023 23:35:19 GMT

Hi. I'm wondering if it is possible to save a matrix or list to a table as a variable, as in:

Names Default To Here(1);
dt = Open("$SAMPLE_DATA/Big Class.jmp");
dt << New Table Variable("Day_mat", [42 43]);

This did not work of course, but is there another way? One option I'm considering is saving it as a table script instead, as in:

Names Default To Here(1);
dt = Open("$SAMPLE_DATA/Big Class.jmp");
dt << New Script("Dat_mat_script", Day_mat = [42 43]);

Just wondering if the community has a better idea? Thanks!

Re: save matrix as table variable?

jthi — Sat, 28 Oct 2023 12:57:28 GMT

I think the table variable has to be either text or numeric value -> you can save it if you convert it into a string (use Char() to convert and Parse() when you need to use it)

Names Default To Here(1);
dt = Open("$SAMPLE_DATA/Big Class.jmp");
dt << New Table Variable("Day_mat", Char([42 43]));

m = Parse(:Day_mat);

Re: save matrix as table variable?

hogi — Sat, 28 Oct 2023 18:10:38 GMT

nice workaround :)

Yes, interesting why there is this restriction for Table variables.

Seems that at the time when Matrices and Lists were introduced in Jmp, development forgot to enable it for table variable.

It could also be intentional that this feature was not added - perhaps to facilitate the input:
if it's no number, it's a string

to allow typing strings without " ..."

If somebody writes a wish list entry, I will support it with a Kudo :)

Re: save matrix as table variable?

jthi — Mon, 30 Oct 2023 14:18:48 GMT

I think Table Variables have specific use and that is why they only support text or values (numeric) Using JMP > Enter and Edit Your Data > Edit Data Tables > Use Data Table Variables , but most likely it could be worth a revisit to allow using at least lists, matrices and associative arrays. I can make a wish list item, though I think JMP development isn't able to keep up to date with them at all currently (we have almost 600 "new" wish list items).

(Created this while writing this post)... Here is the wish list item

Re: save matrix as table variable?

hogi — Mon, 30 Oct 2023 15:34:44 GMT

@jthi wrote:
we have almost 600 "new" wish list items

Yes, seems that since ~ end of 2022 just a small part of the new wishes got acknowledged.

I guess this is due to rfinal phase of Jmp18 development.

Let's hope that after the release of Jmp18 they will start again to acknowledge the new wishes and transfer the good ones to investigating and delivered ....

Re: save matrix as table variable?

nikles — Tue, 31 Oct 2023 16:25:27 GMT

Thanks @jthi. I like this idea too.