Matrix Search using Array Vector in Prime 3.1

Forum|Forum|9 years ago
November 22, 2016
2 replies
3316 views

Hi,

I was looking for a way of easily searching a data matrix "lookup table" with an array vector to extract a value for use in later calculations. I've seen a post where a single value is used to extract a row of data (I need to extract one row of a matrix) and was wondering if this can be somehow extended to be an vector array to extract a single value "alpha". A nominal array and the proposed data matrix would be similar to that below. I've attached a worksheet if that assists?

Also saw this Build New Matrix by Selecting Specific Columns of Another Matrix maybe this has potential to offer an alternate way of extracting the row then alpha value using this as an approach, cant quiet get my head around the matrix math to see a way through...

Thanks in advance

Message was edited by: Peter Darby

1_DataMatrix-Search-mcdx.zip

Statistics_Analysis

W

Werner_E

25-Diamond I

Maybe you are looking for something like this:

Some rudimentary error handling implemented.

If the last argument is a valid column header, just the value(s) in that column are returned, otherwise the full rows.

1_LookFor_WE161123-mcdx.zip

P

pdarby

Author

1-Visitor

Hi Werner,

Many thanks, I'm currently thinking my way through the method supplied - the matrix math its relatively new so it might take a couple of goes to absorb it. The error handling is good, till now hadn't thought much about that.

W

Werner_E

25-Diamond I

Peter Darby wrote:

Hi Werner,

Many thanks, I'm currently thinking my way through the method supplied - the matrix math its relatively new so it might take a couple of goes to absorb it. The error handling is good, till now hadn't thought much about that.

I tried to provide a more general utility which works for any header expressions and any type of table values. That way it looks (and is) more complicate.

Feel free to come back and ask if you experience any confusion.