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
Hi John,
I think it's better to create another manual log table with those additional columns and the record ID to match with the original data record Ids, this way you will be able to merge the tables and expand the additional columns.
