Can I create a lookup table without uploading any of data?

Hi Jorge C., 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> 👋

I'm sorry, but the knowledge sources do not mention the ability to create a lookup table in Mixpanel without uploading any data. All documentation and examples specify that a lookup table requires at least a CSV file with a join key column and one or more property columns to be uploaded during creation. There is no reference to creating an empty lookup table or a lookup table without data in the provided sources Lookup Tables: Enrich ingested data using a CSV.

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

Let me check the knowledge base for you again. One moment! 📚

Mixpanel’s Borrowed Properties feature allows you to “borrow” a property from a prior event and apply it to a later event, but not the other way around. Specifically, you can only carry a property from an earlier event (like Event A) to a later event (like Event B) within a 7-day lookback window. The property is borrowed from the most recent prior event where it is set. There is no functionality in Mixpanel to retroactively carry a property from a later event (Event B) back to an earlier event (Event A), even if both share a unique ID such as common_id Borrowed Properties.So, in your scenario, you cannot use Borrowed Properties to bring a property from Event B (which happens later) to Event A (which happens earlier). The borrowing mechanism only works forward in time, not backward.

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

Let me check the knowledge base for you again. One moment! 📚

Based on the knowledge sources, Lookup Tables in Mixpanel are designed to enrich event or user profile properties with additional metadata by joining on a shared key (such as your common_id). However, Lookup Tables do not allow you to dynamically transfer or "carry" a property value from one event to another if that property was not present on the original event at the time it was ingested.Lookup Tables work by mapping additional attributes to an existing property value (the join key) across all events where that property exists. For example, if both Event A and Event B have a property common_id, and you upload a Lookup Table that maps common_id to some metadata, both events can be enriched with that metadata. But if the property you need only exists on Event B and not in your Lookup Table, Mixpanel cannot use the Lookup Table to "pull" that property onto Event A retroactively Lookup Tables: Enrich ingested data using a CSV.In summary: - Lookup Tables can enrich events with static metadata based on a shared key. - They cannot be used to transfer dynamic property values from one event to another if those values are not present in the Lookup Table itself.If you need to carry a property from Event B to Event A, neither Lookup Tables nor Borrowed Properties can accomplish this in Mixpanel as of now.

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