Hi, When importing 5 worksheets (with the same format name, but not tables) into query from folder, it only had one table to choose from in the edit. So I had to choose the table, as it looks like in the following 3 attachments. The table has a funny name with numbers (attachment1) And there were no sheets listed (like the ones you have in the presentation) so I had to choose that table. After I chose the table (attachement2) and clicked ok to combine, it came up with error and did not show the months except for January, the first file (attachment 3)
I know I have not done all the exercises, but I need to combine data urgently, so I need your help, thank you
Hi Junko,
No images attached. Can you please upload them again. Be sure to click the yellow 'start upload' button.
Thanks,
Mynda
Sorry about that, I will attach the 3 attachments, and 5 worksheets that I was trying to import
I just sent 5 worksheets, but the one with number 4 and 5 are corrupted So I reworked again with 1-3 worksheets but still has error message when I try to see all 3 worksheets...
Hi Junko,
The sheet tabs in each file have different names, so it can only find the data in the first file because it's then looking for sheet tab 20190125154654 in the subesquent files and can't find them. The sheet names must be the same in each file.
Mynda
Hi,
When you import data from a folder,you should avoid the automatic Combine command.
Instead, choose Transform data, and add a new column with this formula:
=Excel.Workbook([Content])
You can remove all other columns and expand the new one, filter the workbook elements you don't need, then expand the Data column and process the data as needed.
Good idea, Catalin. Junko, you can see this process in the second video on the page for lesson 2.05.
