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.
I've been trying to look through other threads like this, but I'm not sure if what I'm looking for is a direct comparison to them.
I have 2 periods of Data from Oct and Nov. I would like to compare each customer data record to see what changes I have in my forecasted customer prices in both files. I guess a unique record for each data point would be a concat of the Bill to ID, Bill to ID Name, Rollup Level Code, Desc, Prod Level 1 Code, Desc, Prod Level 2 Code, Desc, Cat #, and Cat Desc.
I want to ideally see which records stayed exactly the same between both files (in terms of the New Price charged to them) with a column showing a flag stating 'Same' or a Difference column showing a '$0' difference. Any records where there is a difference, I would ideally like to have that Difference column showing the $ difference between both files. There could be records that exist in only Oct or only Nov, so I would like a flag to show that as well. I tried using Joins and joined the left and right sides, but honestly not sure if I'm doing it correctly. I'm not sure how to get the layout I'm looking for.
Customer Data columns....... Old Price New Price Incr $ Difference ($) Exist in which file (Both, Oct only, Nov only)
I feel like this should be a relatively easy thing to do, but I'm running into a lot of issues. Any help would be greatly appreciated.
I think I attempted doing what you're saying. However, I'm not sure if this is an error in my own data or my concat I am basing this off of, but when using the Summarize tools for my Left and Right outputs, I wouldn't expect to see any records with a PI Date of July, Aug, or September in either of the outputs that didn't match. And in the Right output where my November file is I wouldn't expect to see any October records that didn't match since those are my Actual numbers that should not have changed in either of the files. Not quite sure what i'm doing wrong with this =/ . I've attached the workflow I have at the moment to this message.