Forum Discussion
Understanding Get Data > Folder Resulting Queries
- Anonymous8 years ago
In your edit queries section, think of each "Query" as a single data source or table. The folders are simply how you wish to organise those queries.
You can extend the queries such that you merge in data from other queries. You can write your own queries that take data from existing queries.
If you import a folder of files, or you import an excel file of multiple tabs, you can end up with multiple queries. This will be because you will be building multiple tables of data, each which need to be considered in singular.
But this isn't possible when setting up an import from a folder. You get many files and folders. Most of these you can rename; however, I need to better understand what they are doing before I go renaming them. Some you can't rename though.
In your edit queries section, think of each "Query" as a single data source or table. The folders are simply how you wish to organise those queries.
You can extend the queries such that you merge in data from other queries. You can write your own queries that take data from existing queries.
If you import a folder of files, or you import an excel file of multiple tabs, you can end up with multiple queries. This will be because you will be building multiple tables of data, each which need to be considered in singular.