How to replace a field with another if exist but keep other if they don't
I have a product table that has a product number in it.
ProductFromCompanyA:
LOAD
[Product Number],
Others
From File;
Then I have a cross reference table.
Pulling from SQL
ProductNumberCompanyA
ProductNumberCompany B
ProductFromCompanyB: LOAD
[Product Number],
Others
From File;
So now I am wanting to create a file that if in the cross reference table CompanyA and CompanyB are found to match then I want to take CompanyBs product number else leave CompanyAs product number.
