Control check if unique values of two tables do not match

[Felipe_Amancio]

Hi Masters

I would like to create a control check step that compares unique values from two tables. One table is the outcome of the input and the other is a mapping table. Thus, whenever there is a new unique value coming from the input table that is not included in the mapping table the control step would identity it. 

On the example below, the mapping table is missing ID 04 and it should be mapped to the North Region. Therefore, the control check should identify ID 04 to be added to the mapping table.

Input table

ID	ID Name	Amount	Date	Mapping Region
01	Test 1	1000	01/15/2023	West
02	Test 2	1250	03/02/2023	East
03	Test 3	3000	02/25/2023	East
04	Test 4	2500	02/13/2023

Mapping Table

ID	Region
01	West
02	East
03	East

Thanks

Felipe Oliveira

[binuacs · Accepted solution]

@Felipe_Amancio Maybe you can update your logic to something like below

[Felipe_Amancio]

Thanks binuacs! That is great!