I’m attempting to filter out duplicate values from a Monday module and having difficulties doing it. I currently have a set up where I list all of the subitems in a board, and then filter them for the specific ones I want. However, there can be duplicate values after this filter, so I need another filter that checks to see if the mappable column value is a duplicate.
I couldn’t see any way to do it using traditional filters so have been attempting to do it using variables. The idea was to set a variable at the start of the scenario as an empty array (that would reset at the start of every scenario), then have a filter that checks if the value is inside of the array. When the mappable column value passes through the filter, I have another set variable module that would add the mappable column value to the array, meaning any duplicate values get filtered out. The issue is that the add() function doesn’t appear to add the column value to the array. I have tried a couple of different ways to get this to work but I’m still having issues so turning to here. Let me know if there’s a simpler way to do this.
I have added screenshots of the initial set variable, the set variable that isn’t adding the value to the array’s output, and the code for the final set variable.