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!
I have 2 transaction files with 150000+ rows each: File A is the older file and File B is the newer one. I need to find which entries from File A disappeared on file B and sum the total amount (debt amount) that disappeared.
I have only managed to create a Unique ID for both files so far - workflow attached.
Try the Join tool. If your file A is the left input anchor and your file B is the right input anchor, and you set up your unique id as the join field, then the Left Output will be records that exist in file A, but not in file B.
See the example for the Join tool. Type Join at the top right, then when Alteryx displays Join under the list of tools, click the button for Example.
Thank you - I think I managed to get the output, but where I am actually stuck is how to output this information in a user friendly way. I would need the missing entries + the values associated to it so I then can calculate what disappeared.