Uploading CSV & XLS files change the current value

0
Hi,   I just want to know what ways I can implement when I upload a csv or xls file. Whenever that data is already uploaded to the system, I just want to update that data.   Thank you in advance.
asked
1 answers
1

Hi,

You can create another entity with same attributes to upload Excel data temporarily. (do the excel configuration accordingly)

In microflow, fetch data from the actual database(where data will be saved finally) using retrieve activity.

Use loop activity and inside activity retrieve single data from newly created entity using xpath for the unique key so that we will get the same record

Then do the comparison using decision activity and then update the data or if its new record create the record. And commit the list.

Hope this helps!

answered