Getting duplicate records for the same employee while importing multiple excel sheets

0
Hi All, I am importing one excel sheet which contain employee details for one month and another excel sheet for another month in the same entity table. But some of the employee details might change from one month to other month. The issue I am facing is that i am getting duplicate records for the same employee with different data (as the data for that employee changed from one month to other). please refer to the below screenshot for same. But in actual scenario the data should be overwrite for that employee with the new data and show only single record. Could anyone suggest how could we achieve this. Thanks in advance, Apurupa
asked
2 answers
1

In the configuration of the Excel template, you can set how you data is imported.

  1. Import action > Synchronize object
  2. Set key on attribute on Employee name
answered
0

Hi Apurupa,

How are you importing? Suggest to use “Excel Importer” module, it allows you to configure insert/update. https://docs.mendix.com/appstore/modules/excel-importer

You can also refer this learning source: https://academy.mendix.com/link/modules/142/lectures/1222/4.1.1-Install-and-configure-the-Excel-Importer-Module

 

- Ishtiaq

answered