I have an application that reads a CSV file, we then use this data and insert into a database. One of the columns is referencing vendors. The CSV references the vendor as text that someone hand types. I’m trying to come up with a good way to take the text, search our vendors table, and instead of inserting as text, I would like to use the ID so we can make use of keys and have things managed in one spot instead of several. One issue is what happens when there is no exact match, or even several matches.
After I read the CSV, I load a power table. They can preview the data before inserting into the DB. I was wondering if I can add another column in the table that shows the vendor matches as a dropdown and if they don’t like what they see they can select the correct one.
Wondering your thoughts on this. I don’t want to fall in the rabbit hole.