I have two datasets that I was able to match with “Work Order Number” through a Join.
Dataset 1 has Product (hand written, so mispellings etc all over the place), Dataset 2 has Product Description pulled from a computer system, so it’s much more accurate.
I would like to replace the values in Product (for dataset 1) ONLY if Product Description in the joined column has data. Otherwise it should keep the old data.