How to Merge Data from Two Tables in Microsoft Customer Insights
Question details
The user wants to know how to combine or merge data from two different tables within Microsoft Dynamics 365 Customer Insights.

- Product
- Microsoft Dynamics 365 Customer Insights
- Device & OS
- not provided
- Scenario
- Merging tables with different data sources, mappings, and relationships for data ingestion and profile unification.
- Observed behavior
- The user needs specific guidance on configuring the mappings and relationships to unify data profiles across multiple tables.
Gather your table structures, identify common key fields, and document your data source details before attempting to unify profiles.
Consult the Microsoft Dynamics 365 Community
Since merging tables in Customer Insights heavily depends on your specific data ingestion and unification requirements, the best approach is to consult the dedicated Microsoft Dynamics 365 Community.
Customer Insights handles complex enterprise data sources and relationships. The exact merging process relies on your specific table mappings and profile unification goals, which are best addressed by Dynamics 365 specialists who can review your exact schema.
Document your table structure, common key fields, and data sources. Note whether you need data ingestion, table relationships, or profile unification.
Navigate to the official Microsoft Dynamics 365 Community at https://community.dynamics.com/.
Submit a detailed question including the structural information you gathered in the first step to get specialized assistance from Dynamics 365 experts.

Manage and Merge Local Data Tables with WPS Office
While Dynamics 365 handles enterprise customer data, WPS Spreadsheet is a powerful, free, and lightweight alternative to Microsoft Excel for merging, cleaning, and analyzing your local tabular data before ingestion. Enjoy full format compatibility and a familiar interface.

Frequently Asked Questions
What information is needed to merge tables in Customer Insights?
You will need to know your exact table structures, the common key fields that link the tables, your data sources, and your specific requirements for profile unification.
Can I merge tables locally before importing them to Customer Insights?
Yes, you can use spreadsheet software like WPS Spreadsheet or Microsoft Excel to clean, format, and merge your tabular data using functions like VLOOKUP before ingesting it into Dynamics 365.
Where is the best place to get Dynamics 365 support?
The official Microsoft Dynamics 365 Community forums (community.dynamics.com) are the best place to get expert help for complex table relationship and mapping questions.




