To see your data again, make hidden rows visible in a Calc spreadsheet. You can also display the spreadsheet's row header if that option is disabled in your copy of Calc.

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 ...