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.
Find answers, ask questions, and share expertise about Alteryx Designer.
General Discussions has some can't miss conversations going on right now! From conversations about automation to sharing your favorite Alteryx memes, there's something for everyone. Make it part of your community routine!
You could use the Join tool to match the client ID and transaction between the 'returned item' data set and the 'all transactions' data set. The Data in the L or R output of the Join (depending on how you configured it) contains what didn't match, i.e. all transactions, minus the returned items.
@klyuka, true! Was trying to show the principle of how to match.
The complete solution depends on what the actual data set @Vincem35 is working on looks like. There could be an item description field or other information (i.e. date of purchase, ...) that could simplify the matching, which means @Vincem35 just needs to change the fields to match on in the Join tool.