COMPARISON IN DATA SET

[lovebau]

What node can i use to achieve the below?

On the expected output, it would mark as “TRUE” if all are under SOLD and will be “FALSE” it there is other description

[MartinDDDD]

Here’s a prototype…

First group by and get the description as a set.
Then use Column Expressions Array Functions to check if the set for each Ref ID contains “SOLD” AND has only one element.

datasetcomparison.knwf (77.1 KB)

[takbb]

Hi @lovebau , you could try doing a GroupBy node, Group by reference Id and create a unique concatenation of Description. Follow this with a Rule Engine setting to TRUE where the concatenation has returned “SOLD” and “FALSE” otherwise.

[takbb]

@MartinDDDD … sometimes the forum is like playing a variation of “snap!”

[MartinDDDD]

you must have posted pretty much exactly at the same time lol

[lovebau]

@MartinDDDD @takbb thank you so much for your inputs! what if I have more than two descriptions? other than SOLD and STALE I have a couple more description would this still work?

[MartinDDDD]

As long as you only want to show true for ids that are all on sold it should work for as many categories as you like w/o need for change.

[takbb]

Hi @lovebau , as @MartinDDDD has said, the various descriptions don’t matter as long as the rule remains the same. Currently it is a binary true/false for “all sold” vs something else. If additional descriptions brings additional rules then a different solution may be required.

[lovebau]

@MartinDDDD @takbb thank you so much for all your inputs! Everything was very helpful