Count arrays in a table

[marian_cretu]

[ FlexSim 19.1.2 ]

Hello guys,

I haave a table where I store as an array all pallet details(code,batch,exp_date etc).

I need a querry to count the sku's and sort by quantity.

Here is the model.

The query works if the values are integers but when I switch to arrays it doesnt work anymore.

Please advise.

Tahnk you.count array.fsm

[philboboADSK · Accepted solution]

@Marian Cretu,

What did you expect it to do with these arrays? An Array is an object. Each one of them is unique, even if they may contain values that are the same as a different Array. Did you expect it to concatenate all the values and then compare that, where each set of concatenated values is the same?

Like this?

count-array_1.fsm

[philboboADSK]

If you want to COUNT or GROUP BY a column, then that column's values need to be comparable literal types, not complex objects like Arrays.

[marian_cretu]

Exactly what I want. Thank you.