Adding Data to existing query table|Power Query|Excel Forum|My Online Training Hub

Hi All,

I have a couple of queries that download csv files from a folder then compare for discrepancies which we then have to log with a supplier works great thanks to help from you guys.

What I would like to do is add a couple of columns to the table so we can mark off if the discrepancy has been logged and the resolution.

Of course when I refresh All the extra columns aren't included so they no longer correspond to the same row/record.

After all that my question is how can I refresh the data while keeping the additional data? Its almost an incremental refresh and in my googling I have seen workarounds involving duplicate queries then using their own table as a source but can't seem to get it to wok with columns added after the table has loaded.

Thanks in advance

John