Joined two datasets - How to replace one column with another, but only for matches?

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.

Hi @sroberts

A similar topic was recently raised by someone else too. Have a look over there and hopefully that is also applicable in your case :wink:

If not, please include some screenshots, samples, workflows etc. so others can accurately provide some help.

2 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.