Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

How to compare EXPLICIT mapping to BETWEEN and LIKE mapping

masakazuenami
6 - Meteoroid

I have the following 2 tables which I need to compare and identify the incorrect mapping records.  The challenge is the mapping schemes are different between those 2 tables.  Table A is the "should be" table, where all records are explicit, or one-to-one relationship.  On the other hand, Table B, which is the table potentially with incorrect records, uses BETWEEN and IN to store the mappings.  What is the best way to go about this?   Thank you for your help.

 

 

Example Match.png

 

 

3 REPLIES 3
RobertOdera
13 - Pulsar

Hi, @masakazuenami 

 

Try this.

It's a heavy application of assumed logic based on your use case.

 

Still, please mark as an acceptable solution + like, if it works for you.

RNO2_0-1591668233458.png

Cheers!

masakazuenami
6 - Meteoroid

Thank you, @RobertOdera !   This works perfectly!

RobertOdera
13 - Pulsar

Hi, @masakazuenami 

You're most welcome!

Cheers.

Labels