Forum Discussion
How handle mass data in Excel (e.g. powerquery) in different sheets per query
Hello everyone, please dont hurt me for this question... I know it is not the ideal way to handle mass data- but I need to try... I got a folder with 10 csv Files which are always under the xlsx ro...
Is there no way to get for each file a different query automatically? Also no option to filter data from one query via Filename on the sheets?
Sensewell Then you could connect to all relevant files in a Folder and just press "Combine". That should automatically add a column Source.Name to the combined table.
Now create a reference to the combined file and filter for the three files from which you want to load the data into an excel sheet. On the Home tab in the Advanced Editor, "Close & Load To..." or right-click on the Query in the Queries & Connections side-bar and select "Load to..." if you close the query earlies as a "connection only". Repeat these steps for the other files. I see no other way.