Mixpanel Community Icon

Merging Property Values: Mapping Property 1 to Property 2

·
·

I would like to merge the property values of 2 properties 1 merged into 1: Property 1 - has 3 values Property 2 - has 4 values Merged property is Property 2, and I want to map the values from property 1 to the values of property 2, to have continuity in the values.

  • Avatar of kapa.ai
    kapa.ai
    APP
    ·
    ·

    Based on the information provided in the knowledge sources, it appears you're looking to merge properties in Mixpanel. This can be done using the Lexicon feature, which allows for merging of event properties. Here's how you can accomplish this: 1. First, ensure you have the necessary permissions. According to the Lexicon documentation, only project owners can merge events and event properties in Lexicon.2. To merge properties: a. Go to Lexicon in your Mixpanel project. b. Select the properties you want to merge. The "Merge" icon should appear. c. Click Merge. A "Merge Properties" window will appear. d. In the "MERGE SELECTED PROPERTIES INTO…" section, specify Property 2 as the property Mixpanel should recognize as the newly merged property name. e. Click Merge.3. After merging, the merged property will appear in the "Status" column as "Merged".It's important to note that merging properties does not affect the raw data. The merging is done at the analysis level, allowing you to use the merged property in your reports and analyses.However, the knowledge sources don't provide specific information about mapping values from one property to another in the way you've described. If you need to create a more complex mapping between property values, you might need to use a different approach, such as creating a custom property or using a lookup table. Unfortunately, the provided knowledge sources don't contain enough information to give a detailed answer on how to accomplish this specific mapping.For more detailed guidance on property merging or advanced property manipulations, I recommend reaching out to Mixpanel's support team or consulting their more detailed documentation.

    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.

  • Avatar of Julie B.
    Julie B.
    ·
    ·

    how do I merge property values