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
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.
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?
treenode labs=token.labels["item"].up; labs.copy(labels(token.item),COPY_FLAG_REPLACE);
15 People are following this question.
FlexSim can help you understand and improve any system or process. Transform your existing data into accurate predictions.
FlexSim is a fully 3D simulation software environment. FlexSim can be used to simulate any process in any industry.
FlexSim®, FlexSim Healthcare™, Problem Solved.®, the FlexSim logo, the FlexSim X-mark, and the FlexSim Healthcare logo with stylized Caduceus mark are trademarks of FlexSim Software Products, Inc. All rights reserved.
