Forum

Adding Data to exis...
 
Notifications
Clear all

Adding Data to existing query table

2 Posts
2 Users
0 Reactions
270 Views
(@lanser)
Posts: 61
Estimable Member
Topic starter
 

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

 
Posted : 17/12/2019 1:43 pm
(@catalinb)
Posts: 1937
Member Admin
 

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.

 
Posted : 19/12/2019 6:14 am
Share: