Skip to main content

Notifications

Dynamics 365 Community / Forums / Finance forum / Data Entities Two Tables
Finance forum

Data Entities Two Tables

Posted on by 362

Hi All,

We have a requirement to import the data in to two tables with single file. For example we have two tables namely StudentsTable and MarksTable and both has a relation with StudentId. Could you please help me in knowing the process of developing a data entity so that when we import data, the respective fields data will be imported in to both the tables based on the record existence.

Regards

Venkat 

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,228 Super User 2024 Season 2 on at
    RE: Data Entities Two Tables

    Are these fields not mandatory; also not in your entity? Have you tried to provide a source file with only the fields which actual has values? So removed columns with no data in it?

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Data Entities Two Tables

    try to sequence your import and could use a composite entity

    data duplication in primary key is probably causing the failures

  • Reliable Profile Picture
    Reliable 2,015 on at
    RE: Data Entities Two Tables

    Hi Venkat,

    Some primary validations takes place at staging level such as mandatory fields, unique index, blank rows etc. Can you check/share 'Staging log details' where AX will show the error column or additional description of error.

    Also, is your entity exporting a data successfully?

    Regards,

    Sangram

  • johnnystruck Profile Picture
    johnnystruck 285 on at
    RE: Data Entities Two Tables

    Hello Venkat,

    This could be a number of issues - often times (especially when using excel) you have inserted blank rows that exist outside the header and lines data. This is not visible so go in to Excel and delete the blank rows outside of the header and lines data.

    Thank you,

    Johnny

  • Venkatdax0 Profile Picture
    Venkatdax0 362 on at
    RE: Data Entities Two Tables

    Thanks Andre and Sangram

    I have followed the approach of adding multiple data sources in to the entity and when i am not giving some values i am getting the error as The data value violates integrity constraints. These fields in which i am not giving the values are not mandatory fields. Could you please help in sharing your thoughts on the error.

    Regards

    Venkat

  • Suggested answer
    Reliable Profile Picture
    Reliable 2,015 on at
    RE: Data Entities Two Tables

    You will get computed columns and virtual fields learning at below link as Andre suggested-

    docs.microsoft.com/.../data-entity-computed-columns-virtual-fields

    Data entity creation -

    dynamicsinsights.com/.../create-data-entity-d365

    Regards,

    Sangram

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,228 Super User 2024 Season 2 on at
    RE: Data Entities Two Tables

    Hi Venkat,

    If you open the Microsoft Docs link as shared above, there is also a topic for computed columns and virtual fields in the menu. This describes how to use it.

  • Venkatdax0 Profile Picture
    Venkatdax0 362 on at
    RE: Data Entities Two Tables

    Hi Andre,

    Thanks a lot. Could you please share me more insights on using computed columns to achieve the solution.

    Regards

    Venkat  

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,228 Super User 2024 Season 2 on at
    RE: Data Entities Two Tables

    Hi Venkat,

    You can read how to create data entities on Microsoft Docs. You can start on this page: docs.microsoft.com/.../design-best-practices

    Based on your table designs, you can use multiple tables in the data entity, or pick one as the master and complete it using computed fields.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,228 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans