Updating Output Table

[JackDanIce]

Hi,

I'm trying to create a process using Power Query where an initial (empty) table is updated with values by a user which then produces an output table.
3 tables: Initial, Input, Output. Input values always overwrite Initial table to produce Output table

Currently, I can update a single record, but if I update another record, the first record I tried to update, reverts to the initial value.

If using SQL/databases I'm looking for an index record update or table persist type action - i.e. to overwrite data. For now, there is no need to roll back or revert to previous states.

With this example file, can anyone advise how to do this? I've included examples of data entry and expected output

PQ Input Output Mock Up.xlsx

Microsoft Excel Workbook

1drv.ms

TIA,
Jack

 

[JackDanIce]

The example from this link has the same problem, it only refreshes one record and changes to any other records are lost:

Replace Records Via Joins in Power Query

I got an email from a friend today who was using some complicated logic to replace specific records in a table with records from another table. His query was running pretty slow, so he reached out for a little help. … Continue reading →

www.excelguru.ca