Forum Discussion
Create Multiple queries from a single table
I am trying to bring in multiple tables and I thought there must be an easier way then manually importing each Query separately. I have a spreadsheet of about 20 or more csv links from Quandl and I w...
Provided that the column names of those tables are all the same, I'd suggest you add a custom column to your existing table with this formula in it:
Table.PromoteHeaders(Csv.Document(Web.Contents([QuerySource]),[Delimiter=",", Columns=5, Encoding=1252, QuoteStyle=QuoteStyle.None]))
This will return the files' contents into your existing table, having all in one place then but filterable (by column "Query/Table Titel") to your hearts contempt. So if you want to produce one report each source/file, you just select a filter criteria on this column when you prepare your reports.
!! You might need to adjust the Delemiter from "," to ";" and the Encoding (1252) to your local settings. You can find them by expanding one single csv file and analysing the automatically created code.