How can I refer to a Lookup Table in the Custom Property formula?
How can I refer to a Lookup Table in the Custom Property formula?
How can I refer to a Lookup Table in the Custom Property formula?
Hi Mikołaj P., Please stand by as I search the Mixpanel knowledge base for an AI-powered answer. I normally take about 15 seconds or so. In case AI cannot answer your question, feel free to reach out to Mixpanel support at mixpanel.com/get-support. If you have follow-up questions for this thread, please tag me again with your question: @kapa.ai <follow-up question> 👋
Feel free to ask a follow-up question once I've answered by mentioning me with @kapa.ai
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.
kapa.ai is still learning and improving, please let me know how I did by reacting below.
ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.