Question: I want to identify and show an error(Incorrect value) when a customer belongs to more than one of them DSD_AM or AM2 or AM3. As
I want to identify and show an error(Incorrect value) when a customer belongs to more than one of them DSD_AM or AM2 or AM3. As one customer can be across AM.., PM..,WKND.. but not across same type of unloading point. How to go about identifying those records
\begin{tabular}{|l|l|l|} \hline Row & UNLOADING_POINT & UNLOADING_POINT_DESC \\ \hline 1 & 29 & DSD_WKND2 \\ \hline 2 & 05 & DSD_PM2 \\ \hline 3 & 04 & DSD_PM \\ \hline 4 & 07 & DSD_WKND \\ \hline 5 & 06 & DSD_PM3 \\ 6 & 08 & DSD_AM2 \\ \hline 7 & 03 & DSD_AM \\ \hline 8 & 14 & DSD_AM3 \end{tabular}
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
Study Help