GetValueByKey - more than one key?

Question

question

Claire Krupp asked Sep 11, '23 Claire Krupp commented Sep 12, '23

GetValueByKey - more than one key?

The getValueByKey command is very useful (although the order of parameters seems backwards to me!), but often I have two keys.

I have been using a standard Table.query with parameters in those cases, but it would be nice to not have to do that - especially if I need to explain it to a customer or colleague who is not familiar with SQL and the $1 format. Any plans to expand this to use two (or more) keys? (Same for get RowByKey)

Thanks!

Software Version:

FlexSim 23.1.3

sql getvaluebykey getrowbykey

5 |100000

Attachments: Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Answer 1 · 2023-09-11T14:25:01Z

Jason Lightfoot answered Sep 11, '23 Claire Krupp commented Sep 12, '23

You can add a column that combines two values into a key that you can then use with getValueByKey()

Just run something like this to create the key column with key value pairs:

Table.query("UPDATE GlobalTable1 SET Keys=ARRAY(Col1,Col2)");

then you can access the values using something like:

t.getValueByKey([2,"B"],4,"Keys");  //returns the value of col 4 by matching the value in the 'Keys' column with the array [2,"B]

getValueByKey_twoKeysInOneColumn.fsm

You could also consider creating a Map for your lookup rather than using a table.

getvaluebykey-twokeysinonecolumn.fsm (30.0 KiB)

· 1

5 |100000

Attachments: Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Claire Krupp commented · Sep 12, 2023 at 03:44 PM

Thanks @Jason Lightfoot that's a good idea.

0 ·

question