Hi @shubh
Challenging question. It reminds me of a forum post some time ago (see this wf on the hub )
For now I created this wf combinations.knwf (111.1 KB). The complexity that I didn’t solve, is how to handle the missing values in your columns, because now they are treated as if the value is 0. And that has an effect on the possible cat combinations. Please let us know if that is a (big) issue. The wf itself creates all possible combinations of column names. These combinations are used as a filter to calculate the sum of these combinations, and check if it equal to the target value.
gr. Hans