SQL select for Row values

Question

question

Raul V asked Apr 26, '23 Raul V commented May 3, '23

SQL select for Row values

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

Software Version:

FlexSim 23.1.1

sql rowheader select

1682523466601.png (11.0 KiB)

queryforrows.fsm (28.7 KiB)

· 1

Jason Lightfoot ♦ commented · Apr 27, 2023 at 01:00 PM

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

1 ·

Answer 1 · 2023-04-26T22:16:20Z

Kavika F answered Apr 26, '23 Raul V commented May 3, '23

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.

· 4

Joerg Vogel commented · Apr 27, 2023 at 05:48 AM

Flexscript Class Api Data object Map()

1 ·

Raul V commented · Apr 27, 2023 at 05:46 PM

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?

0 ·

1682617183202.png (101.8 KiB)

1682617385650.png (25.0 KiB)

Jason Lightfoot ♦ Raul V commented · Apr 30, 2023 at 11:38 PM

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

2 ·

Raul V Jason Lightfoot ♦ commented · May 03, 2023 at 12:57 PM

Thanks a lot,

0 ·

question