Hello,
I was wondering if it is possible to update an excel table using power query. Any help would be appreciated. Here is my scenario.
I have a spreadsheet on a SharePoint which I need to keep updated. The Peculiarity with this spreadsheet is that I need to updated using records from 2 or more systems and people from my team can also update it manually.
The systems provide the record number, priority, Status, Description, department, etc..
The users update manually the risk fields by giving a risk profile (2 letters), descriptions, Planned resolution date.
The users may also manually enter a record that does not live in the system.
The tasks is to be able to update the table without loosing data.
- If the records exist in the table, updated it without over writing the risks fields
- if the records do not exists in the table, add the record with blank risk fields
- if the records exists in the table but not in the import, do nothing leave it as is in the table.
The imports are in CSV and EXCEL format.
Regards,
I was wondering if it is possible to update an excel table using power query. Any help would be appreciated. Here is my scenario.
I have a spreadsheet on a SharePoint which I need to keep updated. The Peculiarity with this spreadsheet is that I need to updated using records from 2 or more systems and people from my team can also update it manually.
The systems provide the record number, priority, Status, Description, department, etc..
The users update manually the risk fields by giving a risk profile (2 letters), descriptions, Planned resolution date.
The users may also manually enter a record that does not live in the system.
The tasks is to be able to update the table without loosing data.
- If the records exist in the table, updated it without over writing the risks fields
- if the records do not exists in the table, add the record with blank risk fields
- if the records exists in the table but not in the import, do nothing leave it as is in the table.
The imports are in CSV and EXCEL format.
Regards,