How to put an array of values into a row or column of a table?

Question

question

Jouky D asked Oct 5, '23 Jouky D commented Oct 5, '23

How to put an array of values into a row or column of a table?

Hello everyone,

I need to put an array of values into a row and other into a column of a table. One way to do it is using a for loop entering value per value, however I don't know if this is the optimal way. Maybe there is a command for that as:
table[Row2][*] = MyArray;

table[*][Col3] = MyArray;

Is there an optimal option than a for loop?

Software Version:

FlexSim 23.2.1

sql tables array

· 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.

Jouky D commented · Oct 05, 2023 at 08:36 AM

In addition, the array has lots of zeros.

0 ·

Answer 1 · 2023-10-05T11:30:10Z

Jason Lightfoot answered Oct 5, '23 Jason Lightfoot edited Oct 5, '23

Assuming you want one value per table cell there is currently no predefined method for this - a loop is your best bet, but you can write a user command to do this quite easily and then reuse it (passing the array as a variant and the table and range you want to apply it to).

You could also suggest an idea on this site that adding or updating a row based on a set of array values would be useful - I'm less sure about the column application and how that might work with, for example, sql.

· 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.

Jouky D commented · Oct 05, 2023 at 01:48 PM

I did it using a for loop. This can be useful with sparse matrix to only take the row, column and value only, and not the zeros. Thank you.

0 ·

Answer 2 · 2023-10-05T09:56:49Z

Joerg Vogel answered Oct 5, '23 Jouky D commented Oct 5, '23

you can change table cell datatype:

aggregate table row or column to array

Aggregate_table_col_row_to_array.fsm

array-in-table-cell.jpg (36.3 KiB)

aggregate-table-col-row-to-array.jpg (90.9 KiB)

aggregate-table-col-row-to-array.fsm (25.6 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.

Jouky D commented · Oct 05, 2023 at 01:54 PM

Thank you for your answer. However, I needed to join the array into the table. Using a for loop is find (I didn't know if there is other optimal commands for that). Thank you!

0 ·

question