I’ve used the Intercom pack to pull in custom attributes from Intercom users. The Custom Attributes column has a list of custom attributes like this:
You can hover over each custom attribute and see what data it’s storing:
I think this column is actually a list JSON values like this:
I want to create a separate column that extracts a single value, such as the value of custom_attribute_2. I can’t figure out how to do this.
I tried [Custom Attributes Column].Nth(2).value, but the custom attribute I’m looking for is in a different position in the list in each row, so that won’t work.
If I knew how to search for the numerical position of a list item, I would do something like this:
[Custom Attributes Column].Nth([Custom Attributes Column].SearchForNumericalPositionOf(custom attribute 2))
There’s probably some way to use the Count() function for this, but I don’t know how.
Here’s an example: