I need your help on removing duplication of same part nos (type:string) . I have around 5000 parts out of which there are many duplicate parts (child parts which are used in multiple Main parts, eg: fasteners).
Also need to calculate total qty before removing the duplicates so that I can use the totat qty no in source for MU generation.
It should work like - remove duplicates as in Excel.
Hope someone can provide me with an idea. I have tried simple for loops, but in vain.
Solved! Go to Solution.
Here is a suggestion.
Assuming that the data is in a table:
Simple, but should be effective.