SQL select for Row values

[Raul_V]

[ FlexSim 23.1.1 ]

Hi team!

I need to create a select considering a row value (right now i use a for cycle but i would like to use a select statement if is possible)

Could you please help me to create a select considering a row value ? for examples

Select colum header and value from row "X" where value in row is different to "0" ?

//Expected value is Type,2,CT,30,Col5,10,Col6,5

Thanks a lot for the support

QueryforRows.fsm

[kavika_faleumu · Accepted solution]

Hey @Raul V, I'm curious as to why you want to use an SQL Table.query() if you are currently using a working for-loop. The performance of the two is nearly identical (considering the SQL query will still have to loop through the table to perform its analysis). SQL would not be ideal for the kind of output you're looking for because it doesn't have an easy way to query Column Headers, especially based upon value conditionals in each column.

Nevertheless, there are a few SQL Queries you could try to use to accomplish your objective. You could try a combination of ARRAY() and CASE-WHEN-THEN-ELSE-END statements to construct something like this:

SELECT ARRAY(CASE WHEN [Col 1] != 0 THEN 'Col 1' ELSE '' END, ...)

You would have to construct a case for every column in your table - if your table has 50 columns, you're writing 50 CASE statements.

You could also try the MAP() function to group the headers and values in junction with the Select statement above, but I am struggling to see a good solution using it.

[joerg_vogel_HsH]

Flexscript Class Api Data object Map()

[jason_lightfootVL7B4]

You would normally use a different table structure for this where your columns are listed as rows in another table.

[Raul_V]

Hello @Kavika F this is a HMLV model where i control the flow item process flow using a global table and where each type goes directly to any process without doing any connection with "A" , each item have diffetnt cycle time depending each processor .

Every time that i create a flow item i need to to create a loop for get the values from the token ( on item creation) this is why i tried to do it with select.

Do you know a direct way to pass all the labels for the token to a flow item without do loops? maybe i can do it only one and use a select?

[jason_lightfootVL7B4]

treenode labs=token.labels["item"].up;
labs.copy(labels(token.item),COPY_FLAG_REPLACE);

[Raul_V]

Thanks a lot,