July 17, 2018
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
November 8, 2013