First column missing in query results

R

rk415

New member
Joined
Apr 8, 2017
Messages
2
Reaction score
0
Points
0
For some reason, the column header is pulling through (Location), yet none of the actual data is.

Some background, the query is pulling data from a folder of files. I'm also calling a function where I'm cleaning up the files a little as well as assessing all of the column headers (as the headers are not consistent from file to file).

Hope this makes sense, and forgive me if I'm missing any critical parts...it's my first time posting to a forum like this.

Thanks!

Robin
 

Attachments

  • test.zip
    57.2 KB · Views: 14
Perhaps I'm missing something but non of the workbooks has any code or formulas. How are you copying the data over to the main workbook.
 
Hmmm....maybe i'm misunderstanding, but all of the queries show up on my end when I click Show Queries. Or do you mean something else?
 
Are the correct workbooks posted in your original posting ?

What do you mean by Show Queries ? I'm running Excel 2007 .. perhaps you have a newer version with an added feature ? Or (more probable) this is
a part of Excel that I am completely unfamiliar with. What a day ! :doh:
 
@Logit, Power Query doesn't exist in Excel 2007. Anything in this subforum (sadly) will be dead to you until you upgrade. (I wish that wasn't the case, as you're missing out on about 20 years of evolution here.)

@rk415, per the email thread we've been involved in:

Miguel Escobar said:
... it appears that you completely remove the Column1 and Column2, and it appears that Column2 is the one that has the info for the Location and that’s why you’re not seeing the Location appear in the output. What you can do is change the function so it doesn’t remove the Column2 and that way you’ll keep the Location. I’m sending you a suggestion that should work. One thing to mention is that finding out the name of the columns in multiple files, where those fields can have more than 10 columns, can be an expensive query and slow down your overall experience. If you hardcode the fields that you want, then it’ll take less time to load, but if a field is not hardcoded then it wont appear on your final output table. I also changed the input that you had on your function as it was also adding an overhead to the query as a filepath function is not something that we encourage people to do when they already connect to a folder.
Click to expand...
 

Attachments

  • Sales by Location - Pull from Folder rev 040417 - Example.xlsx
    21.7 KB · Views: 5
My fault. I didn't review the section heading for this Thread. My apologies.
 
You must log in or register to reply here.
Back
Top