How to convert a table to an array

Question

question

Julio R asked Jun 23, '22 Julio R commented Jun 23, '22

Hello,

I am doing an SQL query and the result is a table with just one column, I want the results in an array and i am using a simple code as such:

Table Busqueda = Table.query("SELECT IEDBDATA.ROW_NUMBER FROM IEDBDATA WHERE [Assembly] = $1","ASDF");

Array arrayFinal;

for(int i=1;i<=Busqueda.numRows;i++){

arrayFinal.push(Busqueda[i][1]);

}

Is there a more direct or simple method than a for loop to transform the Table into an Array?

Software Version:

FlexSim 22.1.2

sql array table

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 · 2022-06-23T16:05:36Z

Jason Lightfoot answered Jun 23, '22 Julio R commented Jun 23, '22

You want the ARRAY_AGG function:

Table result=Table.query("SELECT ARRAY_AGG([Col 1]) FROM GlobalTable1");
return result[1][1];   //returns the values in 'Col 1' as an 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.

Julio R commented · Jun 23, 2022 at 04:50 PM

Thanks @Jason Lightfoot , thats exactly what I wanted

0 ·