The first set of data contains a column “SupplierTitle” which i am matching against “Company Name” is the second set of data. I am trying to duplicate the “SupplierTitle” column so i can keep the original but also a duplicate column called “SupplerTitle2” which will contain the wildcards.
I’ve added a message box to my wildcard sequence which just shows the last entry with the wildcard. In the output though it just shows the original “SupplierTitle2”.
Test.xlsx (29.4 KB)
FAME Validation.xaml (34.6 KB)