To refer to a Lookup Table in a Custom Property formula, you can use the mapped property name followed by the lookup table column name. Here's how you can do it:
1. First, ensure that you have uploaded and mapped your Lookup Table to a specific property in Mixpanel's Lexicon.
2. In your Custom Property formula, you can reference the Lookup Table columns by using the format: mapped_property.lookup_column_name
For example, if you have a Lookup Table mapped to the song_id property, and it contains columns like artist, genre, and release_date, you can refer to these in your Custom Property formula as:
```
song_id.artist
song_id.genre
song_id.release_date
LBKSThis approach allows you to use the Lookup Table data within your Custom Property definitions, enabling you to create more complex and data-rich custom properties.
For more information on Custom Properties and how to create them, you can refer to the [Custom Properties documentation](https://docs.mixpanel.com/docs/features/custom-properties#creating-a-custom-property).
[Lookup Tables documentation](https://docs.mixpanel.com/docs/data-structure/lookup-tables) provides additional details on how Lookup Tables work and how they can be used to enrich your Mixpanel data.
