Combining Data with an Excel that will be used by end users.

Adam_B

I have two data sets, the left data set has changes from an Excel Sheet that will be used ongoing, that I need to append to the right data set. These changes will need to be made depending on the scenario identified.  I have filters in place and they work, I'm struggling to find where I combine or join the two data sets after they've gone through and appropriate filter on the left data set. At this point I'm not sure where to go from where I am in my workflow.

Any direction would be appreciated thank you!!

Adam 

Incoming Excel from end users.xlsx

Master Data.xlsx

npariso

You can use the Find Replace tool to overwrite any fields that you are planning to replace.

Using the unique ID from each input, you can choose which fields to replace, or you can also append fields that are not present in both data sets.

The 'F' input anchor on the find and replace tool should be the input for the original/master data set.

Let me know if this works!