Hi Athulya,

It's hard to tell you exactly without seeing your logic, but I'm assuming that your entity has sn autonumber id, and so at some point you are probably turning your excel into a record list, and then loop through it with a ForEach, doing a CreateOrUpdare.

Inside that loop, you must first do an aggregate to fetch the record, based on whatever piece(s) of data you have in your excel that uniquely identify each record.

Then do an Assign, assigning all values of the aggregate result from the excel record, but not the id.  Then do your CreateOrUpdate.

Dorine 

Hi Athulya,

The issue is that whenever you upload it will create new record.

In this case, I think you need to have a check before save a record. 

You need to define where is the unique key (for example column 1 and column 2 is a unique key). Then you can check if record already exist by for example using Aggregate and filter by column1 and column2 if return not empty => existed.

Based on exist or not then you can create or update the record.

Hope you get the idea.

Regards,

Khuong

Hello,

Are you trying to Upload and Bootstrap your data into entity which is saved in your excel file, or you are uploading and saving excel file as well in your data base. Or you just want to Upload the file and bootstrap the Excel data into your Entity database.

Please let me know what it is so, it would be clear and if you could attach Oml or some snapshots what you are trying and what you want to achive it will really help

Thanks

Hi Athulya Panicker 

For that you need first to clear the previous  data and then upload the updated file again in the same given format.

for that kindly follow the oml file

hope that will help you..

Kind regards