AnsweredAssumed Answered

Load CSV into a database and also Lookup for missing data from another file before loading

Question asked by Abhijeet Tiwari on Nov 21, 2018
Latest reply on Nov 23, 2018 by Ana Gonzalez

A flat file (CSV: “sales_data.csv”).) need to load into a database so that

mailing lists can be generated from it.

Several of the customer records are missing postal codes (zip codes) that must be resolved before

loading into the database (Lookup input data file is “Zipssortedbycitystate.csv”).

 

The data are loaded into any database.

Outcomes