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.