Skip to main content

Hello Pigment Community,

I’m currently facing an issue with counting duplicate items in Pigment. As shown in the image below, I’ve successfully extracted words from a sentence. Now, I’d like to conditionally format and highlight repeated words starting from their second occurrence.

I understand that using a counter to track how often a word appears is key here, but I’m struggling to come up with the correct formula to achieve this.

Could someone kindly guide me on how to proceed? Your help would be greatly appreciated!

Thanks in advance!
 

 

Here’s how I would approach it:

  1. Create a new metric: RunningTrim

    • Use the following formula to concatenate all the previous Trim items.
    • Notes : I’ve added a logic to ensure we remove any leading or trailing commas for a cleaner result, but the formula could be simplified.

  2. Create a boolean metric: Check

    • Use the following formula.

       

  3. Apply conditional formatting on Trim based on the Check value equals to TRUE. It will highlight cells you expected.

 

Let me know if this helps or if you need further clarification!

 

Reply


Ask your question here!

Terms & ConditionsCookie settings