Others

How to Merge Data from Two Tables in Microsoft Customer Insights

Anum MushtaqAnum Mushtaq Oct 13, 2026 869 views

Question details

The user wants to know how to combine or merge data from two different tables within Microsoft Dynamics 365 Customer Insights.

How to Merge Data from Two Tables in 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.
Before you start

Gather your table structures, identify common key fields, and document your data source details before attempting to unify profiles.

Solution 1Recommended

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.

1
Prepare your data details

Document your table structure, common key fields, and data sources. Note whether you need data ingestion, table relationships, or profile unification.

2
Visit the Community Forum

Navigate to the official Microsoft Dynamics 365 Community at https://community.dynamics.com/.

3
Post your query

Submit a detailed question including the structural information you gathered in the first step to get specialized assistance from Dynamics 365 experts.

Consult the Microsoft Dynamics 365 Community
Provide Context: The more detail you provide about your data sources and mapping requirements, the faster the community can provide an exact solution for your table merge.
Free Microsoft Office alternative

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.

Seamless compatibility with Microsoft Excel (.xlsx, .csv) formatsEasily merge local data tables using built-in formulas and query toolsLightweight software with low system requirementsFamiliar user interface for a zero-learning-curve transition
microsoft office alternative - wps office

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.