DATA with multiple dispositions to be filtered

[Adam_B]

Hello, 

I have a data set that has many different dispositions that will need to be filtered and removed and/or changed within the master data.  

This incoming data is a form that users submit requesting dispositions of diverse suppliers to be removed or changed.  The Master data has over 2M records, however can be associated to the ERP Supplier ID, both data sets have that identifier. 

Below is examples of both data sets.  I don't know where to begin with this.  

Incoming Form example

Master Data Example

[NMangera · Accepted solution]

Hi @Adam_B,

Start by using the join tool to identify the records that need changing with the output nodes Left, Right and Join. The Filter tool can then separate dispositions requiring a single modification (add/remove) and those requiring multiple. From here, implement the appropriate logic as required. 

[Adam_B]

@NMangera Thank you!!! That should work. 

Adam