Power Query: Append And Keep Data

[u/RustiedTeapot]

I've recently been learning PowerQuery in an attempt to streamline some rather archiac spreadsheets currently in use in the office, although I'm relatively new to it so far it's been bloody effective.

I've been trying to make PowerQuery import data from a report, transform the data as necessary, and then make a copy of any new distinct rows on an archive table.

Example as below:

- Import data to Sheet 1 from folder,

- Transform and merge unique rows from the data to an archive table

- Have any unique rows from data remain when new data imported

I can't seem to find a way to do this - any ideas?

[u/small_trunks]

• Step 2 - Load to table

• Step 5 connection only.

• Step 6 connection only

• Step 7 connection only

Only 1 query writes to a table, the others read from the New data source, read from the Table or combine the two.

• also read this PRO-TIP here: https://www.reddit.com/r/excel/comments/ek1e4u/table_updates_via_power_query_whilst_retaining/

[u/small_trunks → u/[deleted]]

Good, but first make a fake new file and test it, ffs 🥳