I am working on a project where I have instructed people to enter a heat number for metal they are testing as it comes in.
Problem is that for a heat example of XYZ 29-30, people have entered it as:
XYZ2930 Xyz 29 30 Xyz2930
I’d love to go through and fix all these for the sake of filtering easier, but this is like, 6 months of data and that would take a very long time. Is there anyway I can fix it faster, or just adjust my query filters? I need to find the average of a quality per heat number.