Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Community is experiencing an influx of spam. As we work toward a solution, please use the 'Notify Moderator' option on the ellipsis menu to flag inappropriate posts.
Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED
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.
Solved! Go to Solution.
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.
Cheers!
