update database with data from excel

faiqz

Hi, I would like to update database with the latest data from excel file.

for example the users entered the wrong phone number in previous week. and this week they sent a correction with the correct information and we need to update the table at the database. The report from excel doesn't have primary key and only the table has them. Do you have any idea how to resolve that?

thank you

Felipe_Ribeir0

Hi @faiqz 

The excel do not have the ID, but have some column/set of columns that identify the row inside the database table right?

You could join the excel file with the database table using this/these columns as key, so you would have the ID and the data that need to be updated on the same dataset. After that, just use the DB output with the proper update config.

Makes sense?