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
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?
try to sequence your import and could use a composite entity
data duplication in primary key is probably causing the failures
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
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
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
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
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.
Hi Andre,
Thanks a lot. Could you please share me more insights on using computed columns to achieve the solution.
Regards
Venkat
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.
#1
André Arnaud de Cal...
291,391
Super User 2024 Season 2
#2
Martin Dráb
230,445
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
