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...
Sensewell The solution is in your last sentence. Connect to each file separately to create 10 queries. Thus, NOT by connecting to all files from a folder.
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?