HI Prateek
Thanks for taking your time to give a script, I appreciate.
However, this is not limited to only this example.
Like, below are some sample materials requests. If you can see, two requestor has requested the same kind of material with different terminologies.
REDUCER CONC BW, SIZE 1(NB):25, Size 2: 15, SCHEDULE/THICKNESS: 40, DIMENSIONAL STD: ASME B16.9, MATERIAL GRADE:ASTM A234 WPB, CERTIFICATION: EN10204 2.2
REDUCER CONC BW, ASME B16.9, size1: DN50, size2: DN40,THK: S-40XS-80, ASTM A234 WPB, Others Requirements: EN 10204-3.1 CERTIFICATE
I want to sort of the maximum occuring materials. In this case, REDUCER CONC BW, is a kind of material that would be requested often, regardless of their sizes.
Hope this is clear.
Regards, Ilyas