Forum Discussion

dnguyen67's avatar
dnguyen67
Frequent Visitor
4 years ago
Solved

Iterate through folder and subfolders to get cvs data

Is it possible to iterate through a folder and subfolders as below, and combine targeted csv files into one table?    for example, I want to get all data (from day 1 to day 30) in one Folder_Jan201...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    If all of the files in the different subfolders have the same structure, you can use Folder.Files, and then the transform query will help you combine them.  If there are differently structured files in each folder, I would replace Folder.Files with Folder.Contents, which will give you a view of the different folders, into which you can drill down into the individual files.

     

    --Nate

Anonymous's avatar
Anonymous
Not applicable
4 years ago

If all of the files in the different subfolders have the same structure, you can use Folder.Files, and then the transform query will help you combine them.  If there are differently structured files in each folder, I would replace Folder.Files with Folder.Contents, which will give you a view of the different folders, into which you can drill down into the individual files.

 

--Nate