This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!
You can take my solution, and modify it slightly so that what doesn't match from the right table will also show in the results. You'd just join back the Customer table to the matched pairs, like I'd done with the Name table to the matched pairs.
If you are only reading the data in, you can manipulate the order with Alteryx and never actually change the source. Just another thing to love about the program.
If any posted solutions help you, please mark them as solved in both threads. Or you can remove one of the threads after you get a solution in the other. That helps when anyone is searching the community for an answer.