Overwrite specific column

[Whoule]

Hi,

We do an extract of SAP to get all items with their current status at the time of the extract. We than use that file to manage workload therefore employees are using this extraction as their worklist for the week. I want to know if it is possible to merge a specific column from their worklist to the next oervall extract. For example:

Both files have unique ID # associated to each transactions therefore is it possible to use this to merge a column named notes to the next full extract we have?

[edhans · Accepted solution]

Don't bring in the original Notes column. Either delete it or select the other columns.

Then merge your file in and keep the Notes column from that.