Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Control check if unique values of two tables do not match

Felipe_Amancio
7 - Meteor

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

IDID NameAmountDateMapping Region
01Test 1100001/15/2023West
02Test 2125003/02/2023East
03Test 3300002/25/2023East
04Test 4250002/13/2023 

 

 

Mapping Table

IDRegion
01West
02East
03East

 

Thanks

 

Felipe Oliveira

2 REPLIES 2
binuacs
21 - Polaris

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

binuacs_0-1683562311968.png

 

Felipe_Amancio
7 - Meteor

Thanks binuacs! That is great!

Labels
Top Solution Authors