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
Solved! Go to Solution.
Thanks binuacs! That is great!