topic How can use a script to match data directly from a matrix? in Discussions

How can use a script to match data directly from a matrix?

lala — Fri, 09 Jun 2023 15:59:55 GMT

For example: Get the memory matrix ar with the following script.
How do match data directly from a matrix with a script?

Achieve something like this:

dt<<Update(With(d2),Match Columns(age=age));

Thanks!

Re: How can use a script to match data directly from a matrix?

jthi — Mon, 10 Oct 2022 04:59:09 GMT

One option would be to first use << Get Rows Where to get row indices for age and then to add the values, but if you don't have to use matrices using JMP's join/update might be faster. So it might be a good idea to create a table from the resulting matrix and then join/update that to the table.