Order "commonality" in Flexsim

Question

question

Marian Cretu asked Aug 24, '20 Ben Wilson commented Aug 31, '20

Order "commonality" in Flexsim

Hello guys,

I have a list of orders in which the sku's are sorted ASC and put inside an array stored on a table.

Like this :

	sku
order_1	(1,3,4,5,8)
order_2	(1,3,4)
order_3	(1,3,4,7)
order_4	(1,4,6,7)
order_5	(4,8,9)
order_6	(1,3,4,8)

Is there a way to build in Flexsim a function/algorithm that finds an order commonality array ?

For this example the function/algorithm should return (1,3,4).

Thanks.

Software Version:

FlexSim 20.1.0

flexsim 20.1.0 orders

· 1

Ben Wilson ♦♦ commented · Aug 31, 2020 at 04:38 PM

Hi @marian.c2, was jordan.johnson's answer helpful? If so, please click the red "Accept" button on their answer. Or if you still have questions, add a comment and we'll continue the conversation.

0 ·

Answer 1 · 2020-08-25T22:54:08Z

Jordan Johnson answered Aug 25, '20

Try something like this:

Table table = Table("GlobalTable1");
Array values;
Array counts;
for (int i = 1; i <= table.numRows; i++) {
    Array skus = table[i]["sku"];
    for (int j = 1; j <= skus.length; j++) {
        Variant value = skus[j];
        int index = values.indexOf(value);
        if (index <= 0) {
            counts[index] += 1;
        } else {
            values.push(value);
            counts.push(1);
        }
    }
}

Array result;
for (int i = 1; i <= values.length; i++) {
    if (counts[i] == table.numRows) {
        result.push(values[i]);
    }
}
return result;

The basic idea is to count the number of times each value occurs. Then, I make an array of the values that were on every row of the table (since their count is the same as the number of rows). However, this won't work if a sku can be in an order more than once. Also, I haven't run the code, so there might be some issues. But hopefully you get the idea.

question