This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I'm drafting a data dictionary for my company. The master document will have the standardized descriptions for the columns of the data we're going to use. We will be doing imports from multiple clients, all of whom might name their columns slightly different names. For example, the master document might say "Vendor_Name" whereas the incoming data from the client might say "Vendor," "Client," "Vendor name," and so on. We're trying to standardize the name of the column so it can be joined with all other clients.
The ideal solution would be for me to be able to have a drop-down tool that takes a look at the column names of the master list and be able to change the column names in the incoming data to the given name before exporting it back out. I saw a couple of other solutions on this site, but they don't quite work. I would greatly appreciate any feedback you folks can potentially provide.