Forum Discussion
Helper IImporting folder takes very long
Super Userhaykp ,
One Option that I could think of is, Instead of selecting the folder at the top most hierarchy, You can create multiple connections ponting to the specific folders from where you want the csv files imported.
Once that is done, you can append all these queries together. This will make everrything a single query for you to report on
haykpThanks for the answer.
Can you please explain more about your suggestion?
Do you mean creating multiple Queryies?
- Thejeswar
Yes, You need to create multiple queries each referring to one folder from where you are getting the file. After doing the below steps, append the queries
a) filter all .csv files
b) filter all the files which start with the given name e.g. fileName_
c) Append all the queries to make them into one
- haykp
Thanks for the answer.
Acutally I am creating the same way, just each of the query takes ages. Also the a),b) steps takes too long.