How to count occurrences for each values in an array?

[Darren_Murphy]

@mikec here is a JavaScript option that I alluded to earlier in the thread:

@Darren_Murphy

If I was to do it using JavaScript I’d still take the same approach, but I’d replace about two-thirds of those columns in the Tags table with a single JavaScript column. Essentially, once you have the Joined List of tags, you can pass that to a JavaScript column and do all the work there.

So the input to the JavaScript column would be the jlTags column, and the output would be the same as the ifTagSummary column.

let arr = p1.split(/,\s?/);
return arr.filter(x => x === p2).length;

Note:

• this is done in the Tags table, not in the Brands table. It’s much easier to do it this way.
• a regular expression is used in the split. This handles the case where there is a space after the comma in the joined list.