I need some help. I have to compare some data that has been flattened out. The differences in the data is that some of the data is from 1 of 2 source systems (CRM1 or OM1). There is a set of part numbers that is common between both source systems. I have to flag part numbers where the price is not the same.
Example of how the data is stored
CustomerNumber CustomerName SrcSystem nrmlzdpn Item Price
85249486 Company X CRM1 CD399A DS100 INK CYAN 1 GALON 303.2
85249486 Company X CRM1 CD400A DS100 1-GAL SPCL TXTL M INK 303.2
85249486 Company X CRM1 CD400A DS100 INK MAGENTA 1 GALON 303.2
85249486 Company X Inc. OM1 CD399A DS100 1-GAL SPCL TXTL C INK 303.2
85249486 Company X Inc. OM1 CD400A DS100 1-GAL SPCL TXTL M INK 308.2
I want to compare for where the customer number is the same, compare against CRM1 against OM1 (the SrcSystem field) where the nrmlzdpn field is the same value, flag if the price isn't the same.
I'm not sure at all how to do this.
Please help
THanks
Example of how the data is stored
CustomerNumber CustomerName SrcSystem nrmlzdpn Item Price
85249486 Company X CRM1 CD399A DS100 INK CYAN 1 GALON 303.2
85249486 Company X CRM1 CD400A DS100 1-GAL SPCL TXTL M INK 303.2
85249486 Company X CRM1 CD400A DS100 INK MAGENTA 1 GALON 303.2
85249486 Company X Inc. OM1 CD399A DS100 1-GAL SPCL TXTL C INK 303.2
85249486 Company X Inc. OM1 CD400A DS100 1-GAL SPCL TXTL M INK 308.2
I want to compare for where the customer number is the same, compare against CRM1 against OM1 (the SrcSystem field) where the nrmlzdpn field is the same value, flag if the price isn't the same.
I'm not sure at all how to do this.
Please help
THanks