For example, we have 10 input fields. we need to set priority for each input field. How do we implement in DMN. The input feed to DMN engine would be array of list. I am not finding any option in FEEL function.

In Excel, there is a feature called, ranking. but i am not finding similar function available in DMN. how do we map the same function in DMN.

@cpbpm please share your example and how it should work. I don’t know this Excel function and how it is used. I think it is valuable to share more details

Thank you McAlm. I see that Hit Policy: Priority is not supported as of 7.12. But in higher version, does this is fixed? I am not finding any reference which states that either supported or not supported.

@Philipp_Ossler, Thank you for your response. In excel there is a function called rank, which is basically sort all the values, based on the value, it will apply ranking values.

Our requirement is basically apply the priority and apply ranking so that highest ranking will be applied.

For example

we have 3 input fields Field A, Field B, Field C, we need apply priority for Field A and ranking. In second iteration we need to choose field B, in third iteration field C. Finally we need to retrieve the row which contains ranking 1 as final output.

In DMN, columns tend to represent ‘AND’, hence for a given row (rule), if there are values in columns A,B,C, the rule is interpreted as If A=x and B=y and C=z then…

Hence, when you say you want to apply ranking across columns, how exactly do you expect this to work? Can you provide a small contrived example?

Hi,
so are you saying the input to columns A,B and C is a list of values for each column or, re you passing in a single value to each column and you want to map these values from their absolute value to their relative values (rank) across the set?

Alternatively, perhaps for each column A,B,C you have a static list of values and when you pass in a variable for a column you want to translate it to its rank according to the columns defined set?

I still dont quite follow what you are trying to achieve…