Today, recorded from #MSIgnite 2019 in Orlando – how to import a CSV file and merge that file with a VLOOKUP table on the way in. This video shows how to use Only Create a Connection in order to define a pointer to the lookup table and the CSV file. Then, a Merge query will solve the problem.