I create a simple view in my database which performs some aggregation to return a resultset containing just two columns. Querying the view returns the expected results.

Fig. 2. shows the mapping of the text file columns to the table columns. Figure 1. Simple data fow from NewStores.txt. Figure 2. How the two text files are mapped. (Click image to view larger ...