Adding new data to a new row of a table.

[Anonymous]

Hello everyone.

I managed to consolidate multiple excel files (slave files) into a master file. Whenever I add a new data/row into one of the slave files, the master file will be updated in a new row based from the file source name. Is it possible to change it whereby the new row will appear at the end of the table and not within the file source name? 

Thanks!

[Jimmy801]

Hello @Anonymous 

Power Query can't know when and what was added to your slave-files. So the only way is to find a sort criteria..

Example timestamp when something was added to your slave-file so you can do a final sort.

If this post helps or solves your problem, please mark it as solution.
Kudos are nice to - thanks
Have fun

Jimmy

[Anonymous · Accepted solution]

Hi

I think this is not precisely correct, what we need is not sort criteria, it is rather some unique Id.
If every row in your data has a unique identifier- e.g. filename + row number- this is reasonably simple to do.

The sequence is:
1. Load existing data - I guess we talk about some form of self-referencing, but how to do it is another story.
2. Load new/updated data
3. Do anti-right(?) join - the idea is to get only rows from the new/updated table that do not match Id in the existing data.
4. Append rows from step 3 to the existing data. In my experience append always happening in the sequence it it defined inside Table.Combine. So the new data will be added to the bottom of the existing.

Kind regards,
JB

[Anonymous]

Hi JB,

Thanks JB! Tested out myself and it nearly worked. Gotta learn more about appending rows as that's where I'm stucked at. Thanky you once again!