file-corretto-professore-autosave-3.fsmHello everybody, I'm Francesco from Italy. I' m going to explain you my problem. I have to manipulate tables in Flexsim and I have to write an alghorithm with the goal to take same data in Flexsim from the table, find element in common in some part of the table. ecc. Is quite difficult to explain here, I would like to know if there is someone that could write me, please write me:[email protected]
Thank you
I will send you an email, but it is best if you post here so that others can benefit from your question.
I have this problem if someone could help me. I'm going to try to explain you with more details and I will try to write a good post, in a case someone in future will need. I have two tables:
First table: ListadoOF_Lectura
Second table:componentes.png
In the first table there is a column called codProducto, in the second table there are two column:the first called "codProducto" and the second called "codComponente".In the second table for each product there is a list of component. What i want to do is:
1 I want to compare each product of the list with the others product of the list for finding how many component in common each product has with others.
example: Prod1=(1,2,3); Prod2=(2,3,4);Prod3=(1,2,3). The Prod1 has 4 component in common.I want to obtain the total number. I want that the total number is showed in the table ListadoOF_Lectura in the last column. I will show you the code that i have, I'm a newbie in coding, so, any advice is good for me. This is the code:
Hi @Francesco V2,
One piece of advice I have would be to create a simple example that does exactly what you need. It sounds like this is what you're looking to do:
1) Starting with the first product in one table, compare the number of the product (i.e. "1") to the other table, one row at a time.
2) Count the instances that match the number of the product (i.e. "1") in the other table.
3) Record the count of instances that match.
You can correct me if I'm wrong. If this is what you're hoping to do, then I recommend Excel or Google Sheets. This is relatively easy in spreadsheet software; is there a reason why you need to do it using FlexSim rather than using Excel and then importing the table into FlexSim?
Thank you tanner.p. I'm not sure if is the same, I will explain better to you to avoid misuenrstanding:
In the second table we have:
| codProd | codComponente |
| 1 | 2 |
| 1 | 3 |
| 1 | 4 |
| 2 | 3 |
| 2 | 4 |
| 2 | 5 |
| 2 | 6 |
The product 1 is composed by (2,3,4) components. The product 2 is composed by (3,4,5,6).
The two products have in common 2 components. And for example I would like to take the product 1 and compare with the other products and calculate the sum of components in common.
I hope is more clear now.
Thanks for the clarification. There are many permutations of products possible - do you intend to check each product against all other products?
For example, if I'm looking at product 1, which has components (2,3,4), am I going to check product 2, 3, 4, ... N to see if they all have 2, 3, or 4?
Or am I checking products 1 and 2, products 3 and 4, products 5 and 6, etc.?
In the code I have used the function Table.query for exctracting data from the table, but I m not sure if is correct.
Here's an idea, @Francesco V2:
You can use a table query for this. I've attached an example model that aggregates the products according to the component. The query selects components, aggregates products, groups by component and orders by component. Hopefully this allows you to then use the array for whatever you need. You could also copy it into another column if you wanted, but I don't know how it would best fit with the other data as there are fewer entries in the aggregated table.
Hello @tanner.p, thank you for your advice bit is not what exactly I wanted to say. I wil try to explain you better with an example:
| Product | Component |
| 1 | 1 |
| 1 | 2 |
| 1 | 3 |
| 2 | 1 |
| 2 | 2 |
| 2 | 4 |
| 3 | 1 |
| 3 | 2 |
| 3 | 5 |
I would like to find the number of products in common that each product has with all the other products. For this example we have:
Product 1:
has in common 2 components with product 2
has in common 2 components with product 3
The total sum is 5 products in common, I'm interested on the number of components in common.
I think there are better pieces of software to use than flexsim for this, but the two ways that you could do this are what tanner said, which is using table queries, or writing complete custom code. I think you should stick with table queries.
Thank you, I would like to try to do it on Flexsim, I have attached an example but I'm not sure if the code is correct, I have used the table queries.
Hello @tanner.p, I have tryed to write a code using a table query but I don't know which kind of mistake i did it. I have used the example that you sent me some weeks ago.
Francesco
Thanks for clarifying that you wanted the sum of the components in common and not the actually component numbers. I wrote a script that will do this in the attached model, but make sure you clear the output table (Global Table 3) before you run the script. I wasn't sure how to add the logic to separate each count by product number, but I'm sure you could get that worked out. You can use this as an example to hopefully achieve what you need.
Here's an updated model that doesn't require resetting the table to be all zeros in between running scripts:
14 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.
