Hi folks,
I got this issue where I need to flag certain records so I can process them differently (or not) based on the count of the number of items per line number. My data looks like this.
I need to update each record with the count (distinct number of items) for each ERP Line Num. My end data needs to look like this. So Each record for ERP Line one would have a 2 since there are 2 items than have ERP Line Num = 1
Any assistance with this is greatly appreciated
Thanks
RJL
I got this issue where I need to flag certain records so I can process them differently (or not) based on the count of the number of items per line number. My data looks like this.
Code:
ERP_Line_Num Item Count
001 0083104
001 0210901
002 0049703
003 0049806
I need to update each record with the count (distinct number of items) for each ERP Line Num. My end data needs to look like this. So Each record for ERP Line one would have a 2 since there are 2 items than have ERP Line Num = 1
Code:
ERP_Line_Num Item Count
001 0083104 2
001 0210901 2
002 0049703 1
003 0049806 1
Any assistance with this is greatly appreciated
Thanks
RJL