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> 👋

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_nameFor 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: LBKSsong_id.artist song_id.genre song_id.release_dateLBKSThis 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.Lookup Tables documentation provides additional details on how Lookup Tables work and how they can be used to enrich your Mixpanel data.

ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.